ASA SQL User's Guide
  Joins: Retrieving Data from Several Tables
    Joins overview

Non-ANSI joins

Adaptive Server Anywhere supports ISO/ANSI standards for joins. It also supports the following non-standard joins:

• Transact-SQL outer joins (*= or =*)

• Duplicate correlation names in joins (star joins)

• Key joins

• Natural joins

You can use the REWRITE function to see the ANSI equivalent of a non-ANSI join.

For more information, see REWRITE function [Miscellaneous].