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. See REWRITE function [Miscellaneous].