SELECTs are not UNION compatible. "Details" (Error 1851)

  • Article

This occurred for one of the following possible reasons:

  • The number of fields do not match. Make sure the number of fields match.
  • The specified fields are not compatible. Make sure the specified fields are compatible.
  • Data types or sizes of fields being projected in each SELECT statement are not identical.