DELETE FROM
    EMP AS e
WHERE
    VALID_FLG <> '1'
    AND EXISTS (
        SELECT
            *
        FROM
            EMP_INVALID AS ei
        WHERE
            e.EMP_CODE = ei.EMP_CODE
    )
;