ASA SQL User's Guide
Transact-SQL Compatibility
This section describes general guidelines for writing SQL for use on more than one database-management system, and discusses compatibility issues between Adaptive Server Enterprise and Adaptive Server Anywhere at the SQL statement level.
General guidelines for writing portable SQL
Creating compatible tables
Writing compatible queries
Compatibility of joins