delete from
    EMP
WHERE
    EMP.EMP_CODE in (
        select
            e.EMP_CODE
        from
            EMP e
            join EMP_INVALID on EMP_INVALID.EMP_CODE = e.EMP_CODE
            and e.VALID_FLG <> '1'
    );