SELECT AM.AM_A, AM.AM_M FROM AM LEFT JOIN AR ON AR.AR_A=AM.AM_A LEFT JOIN SA ON SA.SA_A=AM.AM_A LEFT JOIN MR ON MR.MR_M=AM.AM_M LEFT JOIN SM ON SM.SM_M=AM.AM_M #LEFT JOIN SR ON SR.SR_M=AM.AM_M WHERE AR.AR_A IS NULL AND SA.SA_A IS NULL AND MR.MR_M IS NULL AND SM.SM_M IS NULL #AND SR.SR_M IS NULL