SELECT
*
FROM
(
SELECT
SF_YHXX.ZCH,
SF_YHXX.BENHAO,
SF_YHXX.YHMC,
SF_YHXX.YHDZ,
SF_QFXX.FSJE,
SF_QFXX.CSFQKJE CSFJE,
SF_QFXX.FJFQKJE FJFJE,
SF_QFXX.PWFQKJE PWFJE,
SF_QFXX.ECJYFQKJE ECJYFJE,
SF_QFXX.JSFQKJE JSFJE,
SF_QFXX.LJCLFQKJE LJCLFJE,
'0.00' WYJ,
SF_QFXX.QKJE QKZJE
FROM
SF_YHXX,
SF_QFXX
WHERE
SF_YHXX.ZCH = SF_QFXX.ZCH
AND SUBSTR (SF_YHXX.BMBH, 1, 1) IN ('1', '2', 'D', 'E')
AND SF_QFXX.LZNY = '201501'
UNION
SELECT
SF_YHXX.ZCH,
SF_YHXX.BENHAO,
SF_YHXX.YHMC,
SF_YHXX.YHDZ,
(SF_SFXX.SSJE - SF_SFXX.SSLJCLFJE - SF_SFXX.YSYSWYJ) FSJE,
SF_SFXX.CSFJE,
SF_SFXX.FJFJE,
SF_SFXX.PWFJE,
SF_SFXX.ECJYFJE,
SF_SFXX.JSFJE,
SF_SFXX.SSLJCLFJE,
SF_SFXX.YSYSWYJ WYJ,
(
SF_SFXX.SSJE - SF_SFXX.YSYSWYJ
) QKJE
FROM
SF_YHXX,
SF_SFXX
WHERE
SF_YHXX.ZCH = SF_SFXX.ZCH
AND SUBSTR (SF_YHXX.BMBH, 1, 1) IN ('1', '2', 'D', 'E')
AND SF_SFXX.LZNY = '201501'
UNION
SELECT
SF_YHXX.ZCH,
SF_YHXX.BENHAO,
SF_YHXX.YHMC,
SF_YHXX.YHDZ,
SF_QFXX_BF.FSJE,
SF_QFXX_BF.CSFQKJE,
SF_QFXX_BF.FJFQKJE,
SF_QFXX_BF.PWFQKJE,
SF_QFXX_BF.ECJYFQKJE,
SF_QFXX_BF.JSFQKJE,
SF_QFXX_BF.LJCLFQKJE,
'0.00' WYJ,
SF_QFXX_BF.QKJE
FROM
SF_YHXX,
SF_QFXX_BF
WHERE
SF_YHXX.ZCH = SF_QFXX_BF.ZCH
AND SUBSTR (SF_YHXX.BMBH, 1, 1) IN ('1', '2', 'D', 'E')
AND SF_QFXX_BF.LZNY = '201501'
UNION
SELECT
SF_YHXX.ZCH,
SF_YHXX.BENHAO,
SF_YHXX.YHMC,
SF_YHXX.YHDZ,
(
SF_SFXX_BF.SSJE - SF_SFXX_BF.LJCLFJE - SF_SFXX_BF.YSYSWYJ
) FSJE,
SF_SFXX_BF.CSFJE,
SF_SFXX_BF.FJFJE,
SF_SFXX_BF.PWFJE,
SF_SFXX_BF.ECJYFJE,
SF_SFXX_BF.JSFJE,
SF_SFXX_BF.LJCLFJE,
SF_SFXX_BF.YSYSWYJ WYJ,
(
SF_SFXX_BF.SSJE - SF_SFXX_BF.YSYSWYJ
) QKJE
FROM
SF_YHXX,
SF_SFXX_BF
WHERE
SF_YHXX.ZCH = SF_SFXX_BF.ZCH
AND SUBSTR (SF_YHXX.BMBH, 1, 1) IN ('1', '2', 'D', 'E')
AND SF_SFXX_BF.LZNY = '201501'
) A
ORDER BY
ZCH