Error 153

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

Item Description

SQLCode

-153L

Constant

INVALID_UNION

SQLState

53026

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2096

Severity Code

16

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com