低效率写法:
SELECT * FROM T1 INNER JOIN T2 ON (T1.FID = T2.ID) LEFT JOIN T3 ON (T2.FID = T3.ID)
高效率写法:
SELECT * FROM T1,T2 LEFT JOIN T3 ON (T2.FID = T3.ID) WHERE T1.FID = T2.ID
低效率写法:
SELECT * FROM T1 INNER JOIN T2 ON (T1.FID = T2.ID) LEFT JOIN T3 ON (T2.FID = T3.ID)
高效率写法:
SELECT * FROM T1,T2 LEFT JOIN T3 ON (T2.FID = T3.ID) WHERE T1.FID = T2.ID