mysql - 如何合并select * 和select count(*)两种结果？

问题描述

问题解答

SELECT s1.*,IF(s2.PID IS NULL,0,1) FROM SM_ORGANIZETION s1 LEFT JOIN (SELECT PID FROM SM_ORGANIZETION GROUP BY PID) s2 ON s1.ID=s2.PID;