select a.* from (select * from intd where xm14='$userr')as a LEFT JOIN (select *,count(*) from shiting group by xm1 ) as b on a.id=b.xm1 where a.xm13='' order by a.id desc
MYSQL经典左联查询
最新推荐文章于 2024-04-16 20:32:38 发布
select a.* from (select * from intd where xm14='$userr')as a LEFT JOIN (select *,count(*) from shiting group by xm1 ) as b on a.id=b.xm1 where a.xm13='' order by a.id desc