DELETE FROM EMP
WHERE VALID_FLG=0
AND EMP_CODE NOT IN (
    SELECT
        EMP.EMP_CODE
    FROM 
        EMP INNER JOIN EMP_INVALID
            ON EMP.EMP_CODE = EMP_INVALID.EMP_CODE
    WHERE 
        EMP.VALID_FLG = 1
    )
;