In this blog post, you’ll learn more about the Sybase Error Number of columns defined for the table does not match SELECT statement and the reason for receiving this error
Sybase SQL Error Message
Number of columns defined for the table does not match SELECT statement
Reason for this Error
You attempted to create a table from a SELECT statement, but the column name list specified as part of the CREATE TABLE statement does not correspond to the list of items in the AS SELECT statement.