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

展开