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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Reference » SQL language elements » Operators


Join operators


Support for Transact-SQL outer join operators *= and =* is deprecated. To use Transact SQL outer joins, the tsql_outer_joins database option must be set to On.

SQL Anywhere supports two additional comparison operators, *= and =*, which are the Transact-SQL outer join operators. When one of these operators is used in a comparison predicate, an implicit LEFT or RIGHT OUTER JOIN is specified.

 See also