Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility » Writing compatible SQL statements

 

Compatibility of joins

In SQL Anywhere's implementation of Transact-SQL, you can specify join syntax from the SQL/2008 standard using the keywords JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN, and FULL OUTER JOIN, along with legacy Transact-SQL outer join syntax that uses the specialty comparison operators *= and =* in the statement's WHERE clause.

Note

Support for Transact-SQL outer join operators *= and =* is deprecated and will be removed in a future release.

For information about joins in SQL Anywhere and in the ANSI/ISO SQL standards, see Joins: Retrieving data from several tables, and FROM clause.

For more information about Transact-SQL outer joins, see Transact-SQL outer joins (*= or =*).

 See also