34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT XMXX.htrq,
XMXX.htmc,
XMXX.ywy,
XMXX.jfxm,
XMXX.dh,
DOC_CPDA.cpmc,
DOC_CPDA.ggxh,
DOC_CPDA.jldw,
(CPXX.sl - a.sl) as wdsl
FROM (select hth,sum(sl) as sl from REC_DH group by hth) a,
XMXX,
CPXX,
DOC_CPDA
WHERE ( a.hth = XMXX.hth ) and
( XMXX.hth = CPXX.hth ) and
( CPXX.cpbh = DOC_CPDA.cpbh )
SELECT x.htrq,
x.htmc,
x.ywy,
x.jfxm,
x.dh,
d.cpmc,
d.ggxh,
d.jldw,
(isnull(c.SL,0) - isnull(r.SL,0)) as wdsl
FROM REC_DH R
left join XMXX x on x.hth = r.hth
left join CPXX c on c.hth = r.hth
left join DOC_CPDA d on d.cpbh = c.cpbh
where (isnull(c.SL,0) - isnull(r.SL,0)) >0