DELETE
FROM
    EMP AS e
WHERE
    e.VALID_FLG <> '1'
AND e.EMP_CODE IN (
    SELECT
        EMP_CODE
    FROM
        EMP_INVALID
)