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;