SET SCHEMA JEMSHDP11;

SELECT * FROM CCFCRPP 
LEFT JOIN CCDCSRP ON BYCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCBRCHP 
LEFT JOIN CCDCSRP ON AECRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCGCRCP 
LEFT JOIN CCDCSRP ON AVCRCD=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCBCRDP 
LEFT JOIN CCDCSRP ON CJCVCH=AXCRCD
WHERE AXCRCD IS NULL;

SELECT * FROM CCCRTDP 
LEFT JOIN CCDCSRP ON A9CVCH=AXCRCD
WHERE AXCRCD IS NULL;