delete from EMP where EMP_CODE = (
select EMP.EMP_CODE from EMP
left outer join EMP_INVALID on EMP.EMP_CODE=EMP_INVALID.EMP_CODE
where EMP_INVALID.EMP_CODE is not null
and (EMP.USER_UPDATE_DATETIME >= EMP_INVALID.USER_UPDATE_DATETIME and EMP.VALID_FLG<>'1')
)