110,534
社区成员
发帖
与我相关
我的任务
分享
select a.xzmc xzmc,a.cm cm,b.cnd cnd,b.srs srs from (select xzbm,xzmc,count(cmc) cm from TableA group by xzbm,xzmc) a left join ((select dqdm,count(data1) cnd,sum(data2) srs from TableB group by dqdm) union (select dqdm,count(data1) cnd,sum(data2) srs from TableC group by dqdm)) b on a.xzbm = b.dqdm order by a.xzbm