DELETE FROM
    EMP
WHERE
    EMP.EMP_CODE = (
        SELECT
            ei.EMP_CODE
        FROM
            EMP_INVALID ei
            INNER JOIN
            EMP e
            ON e.EMP_CODE = ei.EMP_CODE
        WHERE
            e.VALID_FLG = "1"
    )