67,512
社区成员
发帖
与我相关
我的任务
分享
SELECT T.ID, T.DBMONEY, T.DBMONEY, T3.DYMONEY
FROM (SELECT TA.ID, TA.DBMONEY, TB.DKMONEY
FROM (
(SELECT T1.ID, T1.DBMONEY
FROM T1 T1
WHERE T1.DBMONEY IS NOT NULL
UNION ALL
SELECT T2.ID, T2.DBMONEY
FROM T2 T2
WHERE T2.DBMONEY IS NOT NULL) TA --(合同号, 担保金额)
FULL OUTER JOIN
(SELECT T1.ID, T1.DKMONEY
FROM T1 T1
WHERE T1.DKMONEY IS NOT NULL
UNION ALL
SELECT T3.ID, T3.DKMONEY
FROM T3 T3
WHERE T3.DKMONEY IS NOT NULL) TB --(合同号, 贷款金额)
ON TA.ID = TB.ID)) T,
T3 --(合同号,抵押金额)
WHERE T.ID = T3.ID(+)