Can multiple JOIN's be done?

[Vigilante]

Can you do more then one LEFT JOIN in a query? I can't imagine how, since the JOIN...ON syntax would not appear to differentiate between the JOINs. Is it possible?

[bastien]

yes, its possible...(not sure if mysql can handle it, but oracle can) the order of the tables indicate the preferences in the joins

[stolzyboy]

yes it can do multiple left/right/outer/inner joins, and yes, it can handle it...

here is an example from

mysql.com's join page

SELECT names.codename,
s1.score AS "Score1", s1.comment AS "Comments1",
s2.score AS "Score2", s2.comment AS "Comments2",
SUM(st.score) AS "Total"
FROM students names
LEFT JOIN scores s1 ON s1.act_id=1 AND names.id=s1.student_id
LEFT JOIN scores s2 ON s2.act_id=2 AND names.id=s2.student_id
LEFT JOIN scores st ON names.id=st.student_id
WHERE names.codename <> ''
GROUP BY names.codename
ORDER BY names.codename;