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 Transact-SQL outer joins (*= or =*).
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. See tsql_outer_joins option.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|