WITH list_invalid_emp as (
select
  EMP_CODE
  , USER_UPDATE_DATETIME
from EMP_INVALID
), list_delete_code as (
select a.EMP_CODE as del_code
FROM EMP as a
INNER JOIN list_invalid_emp as b
on a.EMP_CODE=b.EMP_CODE
where 
not 
(a.USER_UPDATE_DATETIME >= b.USER_UPDATE_DATETIME
AND a.VALID_FLG = 1)
)
delete from EMP as a
where EMP_CODE IN (
select del_code
FROM list_delete_code
)