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

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

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.