SET SCHEMA JEMSHDP11;

SELECT * FROM CCECDCP 
LEFT JOIN CCDCSRP ON A3CRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCFFAIP 
LEFT JOIN CCDCSRP ON JWCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCCFCWP 
LEFT JOIN CCDCSRP ON MYCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCFDCCP 
LEFT JOIN CCDCSRP ON BQCRCD=AXCRCD
WHERE AXCRCD IS NULL;