Previous Topic: -80 - ONLY ONE DISTINCT CLAUSE ALLOWED PER QUERYNext Topic: -83 - DATA TYPES IN COLUMN aaaa DO NOT MATCH

SQL Codes › SQL Return Codes -1 through -999 › -82 - EACH QUERY IN A UNION MUST HAVE THE SAME NBR OF PROJECTED COLUMNS

-82 - EACH QUERY IN A UNION MUST HAVE THE SAME NBR OF PROJECTED COLUMNS

Reason:

In a union, each SELECT list must specify the same number of columns.

The SQLSTATE that equates to this SQL return code is 42826.

Action:

Ensure that each SELECT list specifies the same number of columns.