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