Shorten a Query

admin

Administrator
Staff member
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
 
Back
Top