SELECT
w.*,
CASE WHEN ws.Wse_Bid IS NULL THEN 0 ELSE 1 END AS bianji,
B.sendflag,B.pcount
FROM WSend_Business w
LEFT JOIN (SELECT WSe_Bid,COUNT(Recphone) AS pcount,MIN(sendflag) AS sendflag
FROM WSend_phone GROUP BY Wse_Bid) AS ws
ON w.bid = ws.Wse_Bid;
--这样试试
