If i want to LEFT JOIN the same table to more than one column, is there a shortcut method, or do i have to write out:
SELECT Table1.Name, Table2.Name Table3.Name from links l,
LEFT JOIN table as Table1 on l.Cat1=Table1.id
LEFT JOIN table as Table2 on l.Cat2=Table2.id
LEFT JOIN table as Table3 on l.Cat2=Table3.id
Thanks
SELECT Table1.Name, Table2.Name Table3.Name from links l,
LEFT JOIN table as Table1 on l.Cat1=Table1.id
LEFT JOIN table as Table2 on l.Cat2=Table2.id
LEFT JOIN table as Table3 on l.Cat2=Table3.id
Thanks