delete from emp where emp_code in
(select
    ei.emp_code
from
    emp_invalid ei inner join emp e
    on ei.emp_code = e.emp_code
where
    e.valid_flg <> 1
)
;
--select * from emp;