Previous Topic: -82 - EACH QUERY IN A UNION MUST HAVE THE SAME NBR OF PROJECTED COLUMNSNext Topic: -84 - ORDER BY ITEMS MUST BE CONSTANTS FOR UNION OF QUERIES


-83 - DATA TYPES IN COLUMN aaaa DO NOT MATCH

Reason:

In a union, the corresponding columns in each SELECT list must have exactly the same description.

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

Action:

Ensure that the columns specified in the SELECT lists are of the same data type, length, and scale.