oracle 语句报错！ ORA-01790: 表达式必须具有与对应表达式相同的数据类型，请大家帮帮忙啊！

Question

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

Answer 1

仔细检查字段类型是否相同 如：
SELECT '01' A ,'字符串1' b FROM DUAL
union
SELECT 02 A ,'字符串2' b FROM DUAL
上下两个A的字段类型不同，要改为一样的。
SELECT '01' A ,'字符串1' b FROM DUAL
union
SELECT '02' A ,'字符串2' b FROM DUAL

Answer 2

UNION 使用必须保证表连接时数据类型是一致的。检查一个类型，你可以少连接几个字段，逐项排查加减字段进行调试本回答被网友采纳

Answer 3

union 和union 的字段的排序需要和后面的排序一致