delete from EMP 
where
  VALID_FLG = '0' and
  exists(
    select 1 from EMP_INVALID b
    where
      EMP_CODE = b.EMP_CODE and
      USER_UPDATE_DATETIME <= b.USER_UPDATE_DATETIME
  )