Forum Moderators: open
in the products table these will be numbers relating to a key in a category table. I can left join the category onto the products table, but then can i additonally join the subcategory and thirdcategory on products?
I'd really like to do so so i can sort properly by either subcategory or thirdcategory name and not just the id number.
select
tbl1.id
tbl2.id
tbl3.id
from
table1 tbl1 left join table2 tbl2 on tbl1.id = tbl2.id
left join table3 tbl3 on tbl2.id = tbl3.id
sort by
tbl2.id
