SELECT tableAlias.fields FROM table AS Alias LEFT JOIN table1 AS Alias1 ON conditions LEFT JOIN table2 AS Alias2 ON conditions按照这个模式写出来就OK了你的问题描述的不是很清楚,我也只能是给你一个模式了!