DELETE 
FROM
    EMP 
WHERE   EXISTS (
    SELECT *
    FROM EMP_INVALID
    WHERE 
        EMP.EMP_CODE = EMP_INVALID.EMP_CODE 
    AND EMP.VALID_FLG = EMP_INVALID.VALID_FLG
);