delete
from 
    emp
where
    emp.valid_flg != '1'
    and emp.emp_code in (
        select
            distinct emp_code
        from
            emp_invalid
    )
;