Sybase database: Two places of special attention

Sybase database: Two places of special attention one, field aliases

A field alias cannot be a column name in a query condition, resulting in inaccurate data being queried; the best field alias is a non-column name;

Second, the case of the updated table name

Update a set ..... Select ... from a ....

The case of a table here will cause the update to be unsuccessful; table names need to be consistent and contain case;

Sybase database: Two places of special attention