In this blog post, you’ll learn more about the Sybase Error Select lists in UNION, INTERSECT, or EXCEPT do not match in length and the reason for receiving this error
Sybase SQL Error Message
Select lists in UNION, INTERSECT, or EXCEPT do not match in length
Reason for this Error
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.