delete from emp t1
where exists (
select * from emp_invalid t2
where t1.emp_code = t2.emp_code
and t1.valid_flg <> 1
and t2.valid_flg = 0
)
;