DELETE
FROM
    EMP
WHERE
    EMP.EMP_CODE IN
    (
        SELECT
            EI.EMP_CODE
        FROM
            EMP AS EP
            INNER JOIN EMP_INVALID AS EI
            ON EP.EMP_CODE = EI.EMP_CODE
        WHERE
            EP.VALID_FLG = '0'
    )
;