iAnywhere.com - Select lists in UNION, INTERSECT, or EXCEPT do not match in length

SQL Anywhere® 10 - Error Messages > Database Error Messages > Alphabetic list of error messages

Select lists in UNION, INTERSECT, or EXCEPT do not match in length

Item	Value
Constant	SQLE_INVALID_UNION
ODBC 2 State	37000
ODBC 3 State	42000
Severity	16
SQLCODE	-153
SQLSTATE	53026
Sybase error code	205

Probable cause

You specified a UNION, INTERSECT, or EXCEPT but the SELECT statements involved in the operation do not have the same number of columns in the select list.