34,838
社区成员




with t1 as
(select dj.yuanGongId,col1=sum(zongJinE-youHuiJinE) from danJu dj inner join yuanGong yg on dj.yuanGongId=yg.yuanGongId
inner join peiJianMoney pjm on pjm.danJuId=dj.danJuId where peiJianId is null and jieSuanId=2 group by dj.yuanGongId),
t2 as
(select dj.yuanGongId,col2=sum(zongJinE-youHuiJinE) from danJu dj inner join yuanGong yg on dj.yuanGongId=yg.yuanGongId
inner join peiJianMoney pjm on pjm.danJuId=dj.danJuId where fuWuId is null and jieSuanId=2 group by dj.yuanGongId),
t3 as
(select dj.yuanGongId,col3=sum(zongJinE-youHuiJinE) from danJu dj inner join yuanGong yg on dj.yuanGongId=yg.yuanGongId
inner join peiJianMoney pjm on pjm.danJuId=dj.danJuId where jieSuanId=2 group by dj.yuanGongId)
select t1.yuanGongId, t1.col1,t2.col2,t3.col3
from t1
inner join t2 on t1.yuanGongId=t2.yuanGongId
inner join t3 on t1.yuanGongId=t3.yuanGongId