Error Message - Union not Supported

Error message (example):

Union is not supported. Use Union All instead


Currently, there is no support for the UNION operation.

UNION removes duplicate records (where all columns in the results are the same. Effectively, this is a  SELECT DISTINCT on the result set.).

UNION ALL does not remove duplicates

Possible Solutions:

If you know that all the records returned are unique from your union, use UNION ALL.

  • 40
  • 26-Jul-2015