Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL 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].
