选择a.spid d.spbh, d.spmch, d.shpgg, d.dw, d.shpchd, a.kcshl, a.kcje, b.hwshl b.hwje c.pcshl, c。pcje从spkfjc
左加入(选择spid、sum (hwshl) hwshl总和(hwje) hwje hwsp group by spid) b a.spid=b。spid
左加入(选择spid、sum (shl) pcshl总和(gebjj * shl) pcje sphwph group by spid) c a.spid=c。spid
加入spkfk a.spid=d d。spid
, b.hwshl <> c。pcshl或b.hwshl <>。kcshl
选择d.spid d.spbh, d.spmch, d.shpgg, d.dw, d.shpchd, b.hw, b.hwshl b.hwje c.pcshl, c。pcje从spkfk d
加入hwsp b d.spid=b。spid
左加入(选择spid、hw总和(shl) pcshl总和(gebjj * shl)从sphwph group by spid pcje, hw) c d.spid=c。spid b.hw=c。hw
, b.hwshl <> c。pcshl