ANSI Joins

ASE now supports ANSI joins. Sybase recommends that you rewrite applications to use ANSI outer joins because they specify unambiguously whether the on or where clause contains the predicate. Transact-SQL syntax in previous releases was ambiguous in some cases.

ANSI syntax allows you to write either of these types of joins:

For more information see the Transact-SQL User’s Guide.