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
人说,如果你很想要一样东西,就放它走 。如果它回来找你,那么它永远都是你的。要是它没有回来,那么不用再等了,因为它根本就不是你的。
——伊恩·麦克尤恩