ORACLE取对照表不等的数据

SELECT A.FALTERID,A.FASSETTYPEID,B.FLIFEPERIODS FROM (
SELECT A.FALTERID,A.FASSETTYPEID,B.FLIFEPERIODS FROM T_FA_CARD A INNER JOIN T_FA_FINANCE B ON A.FALTERID = B.FALTERID
WHERE A.FDOCUMENTSTATUS = 'C' AND A.FFORBIDSTATUS = 'A' AND A.FASSETCURSTATUS = '1' AND A.FASSETORGID=101712
) A,(SELECT b.fassettypeid,(b.FENTDEPRYEARS*12) FLIFEPERIODS FROM T_FA_ACCTPOLICY A INNER JOIN T_FA_ACCTPOLICYASSET B
ON A.FACCTPOLICYID = B.FACCTPOLICYID
WHERE A.FUSEORGID = 101712) B
WHERE A.FASSETTYPEID = B.FASSETTYPEID
AND A.FLIFEPERIODS <> B.FLIFEPERIODS

posted @ 2021-01-11 18:25  CH|heyi  阅读(128)  评论(0编辑  收藏  举报