I have a question for the SQL experts on the list if possible.
Is it possible in MySQL to have two (multiple) LEFT OUTER JOINS in a command? Or is there another way to do this? IE: SELECT t1.id, t1.var1, t2.var1, t3.var1, t4.var1 FROM Table4 t4 LEFT OUTER JOIN Table2 t2 ON t2.id = t1.id LEFT OUTER JOIN Table3 t3 ON t3.id = t1.id WHERE t1.id = t4.id ORDER BY t1.var1 ASC, t3.var1 ASC Thanks Steve Fogelson ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
