delete from EMP 
where
  VALID_FLG = '0' and
  exists(
    select 1 from EMP_INVALID b
    where
      EMP_CODE = b.EMP_CODE and
      b.VALID_FLG = '0' and
      b.USER_UPDATE_DATETIME <= datetime(CURRENT_TIMESTAMP, '-6 months')
  )