FROM AMLM.T09_CUST_PENDING T1
JOIN (SELECT CUST_NO
FROM AMLM.T00_CUST A
WHERE EXISTS (SELECT T.REGION_CODE, T.SEQ_NO
FROM AMLM.T12_FAULT_REGION T
WHERE SUBSTR(A.IDCARD_NO, 1, 6) = T.REGION_CODE
AND SEQ_NO IS NOT NULL)) T6 ON T6.CUST_NO = T1.CUST_NO
GROUP BY T1.CUST_NO', '1', '', 'RISK', '010043707008657');
[复制链接]
发表于 2015-1-21 16:44:52
