sql 子查询开发总结

sql 子查询开发总结

<?php 

$sql = "
		SELECT a.unid,b.* FROM tab1 AS a 
		LEFT JOIN 
		(
			SELECT unid,count(c.list_suiji) AS cnt FROM 
			(
				SELECT unid,list_suiji FROM tab2 GROUP BY unid,list_suiji
			) 
			AS c WHERE 1 GROUP BY unid 
		) AS b ON a.unid = b.unid 
		WHERE a.delete_flag = 1 
		";

?>