問題描述

問題解答

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;