DELETE
FROM
    EMP
WHERE
    EMP_CODE IN
    (
        SELECT
            EMP_CODE
        FROM
            EMP_INVALID
    )
AND COALESCE(VALID_FLG, '') <> '1'
;