select count(*) from (select lt.id from table1 as t1 LEFT JOIN table2 as t2 on t1.id = t2.c_id GROUP BY t1.id) as t
记一下,别到时候又忘了,要去搜索
select count(*) from (select lt.id from table1 as t1 LEFT JOIN table2 as t2 on t1.id = t2.c_id GROUP BY t1.id) as t
记一下,别到时候又忘了,要去搜索