SET SCHEMA JEMSHDP12;

SELECT * FROM CCECSCP 
LEFT JOIN CCDCSRP ON A1CRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCFMERP 
LEFT JOIN CCDCSRP ON FLCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCFECCP 
LEFT JOIN CCDCSRP ON C9CRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCFJUCP 
LEFT JOIN CCDCSRP ON CNCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCFJOCP 
LEFT JOIN CCDCSRP ON CYCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCFEPCP 
LEFT JOIN CCDCSRP ON E6CRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCBSEHP 
LEFT JOIN CCDCSRP ON BOCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCASHFP 
LEFT JOIN CCDCSRP ON BOCRCD=AXCRCD
LEFT JOIN CCACASP ON BOCRCD=A0WTCF
WHERE AXCRCD IS NULL AND A0WTCF IS NULL;