先连接后条件过滤 SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.ID=TABLE2.FKID WHERE TABLE2.ROLE IS NULL; 先条件过滤后连接 SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.ID=TABLE2.FKID and TABLE2.ROLE IS NULL;