Error Message - Union not Supported

Error message (example):

Union is not supported. Use Union All instead

Meaning:

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
  • 339 Views