SELECTGY_YLSF.FYMC,GY_YLSF.FYDW,GY_YLSF.FYDJ,MS_YJ01.YSDM,MS_YJ01.KSDM,GY_KSDM.KSMC,SUM(MS_YJ02.YLSL)ASFYSL,SUM(MS_YJ02.HJJE)ASHJJEFROMGY_KSDM,MS_MZXX,MS_YJ01,MS_YJ02,GY_...
SELECT GY_YLSF.FYMC,
GY_YLSF.FYDW,
GY_YLSF.FYDJ,
MS_YJ01.YSDM,
MS_YJ01.KSDM,
GY_KSDM.KSMC,
SUM(MS_YJ02.YLSL) AS FYSL,
SUM(MS_YJ02.HJJE) AS HJJE
FROM GY_KSDM,
MS_MZXX,
MS_YJ01,
MS_YJ02,
GY_YLSF
WHERE ( MS_MZXX.FPHM = MS_YJ01.FPHM ) and
( MS_YJ01.YJXH = MS_YJ02.YJXH ) AND
( GY_KSDM.KSDM = MS_YJ01.KSDM ) AND
( MS_MZXX.MZLB = 1) and
( MS_MZXX.HZRQ >= 2012-11-11 ) and
( MS_MZXX.HZRQ <= 2012-12-11) and
( MS_YJ02.YLXH = GY_YLSF.FYXH ) AND
( GY_YLSF.FYGB = 1)
GROUP BY MS_YJ01.YSDM,
MS_YJ01.KSDM,
GY_KSDM.KSMC,
GY_YLSF.FYMC,
GY_YLSF.FYDW,
GY_YLSF.FYDJ
union all
SELECT GY_YLSF.FYMC,
GY_YLSF.FYDW,
GY_YLSF.FYDJ,
MS_YJ01.YSDM,
MS_YJ01.KSDM,
GY_KSDM.KSMC,
0 - SUM(MS_YJ02.YLSL) AS FYSL,
0 - SUM(MS_YJ02.HJJE) AS HJJE
FROM GY_KSDM,
MS_ZFFP,
MS_YJ01,
MS_YJ02,
GY_YLSF
WHERE ( MS_ZFFP.FPHM = MS_YJ01.FPHM ) and
( MS_YJ01.YJXH = MS_YJ02.YJXH ) AND
( GY_KSDM.KSDM = MS_YJ01.KSDM ) AND
( MS_ZFFP.MZLB = 1) and
( MS_ZFFP.HZRQ >= 2012-11-11 ) and
( MS_ZFFP.HZRQ <= 2012-12-11 ) and
( MS_YJ02.YLXH = GY_YLSF.FYXH ) AND
( GY_YLSF.FYGB = 1)
GROUP BY MS_YJ01.YSDM,
MS_YJ01.KSDM,
GY_KSDM.KSMC,
GY_YLSF.FYMC,
GY_YLSF.FYDW,
GY_YLSF.FYDJ
展开