Forum Moderators: coopster
I believe (hope) these two approaches produce the same results, joining the 4 tables.
Is either more efficient?
Approach #1
FROM table1, table2, table3
LEFT JOIN table4 ON table4.WebID = table3.WebID
WHERE table1.ID = table2.ID
AND table2.CityID = table3.CityID
Approach #2
FROM table1
INNER JOIN table2 ON table1.ID = table2.ID
INNER JOIN table3 ON table2.CityID = table3.CityID
LEFT JOIN table4 ON table4.WebID = table3.WebID