delete from emp
where
    valid_flg = 0 and
    emp_code in (
        select emp_code
        from emp_invalid
    )
;