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