Support for Transact-SQL outer join operators *= and =* is deprecated and will be removed in a future release.
There are several restrictions for Transact-SQL outer joins:
WHERE R.x *= S.x AND S.y = T.y
When you cannot rewrite your query to avoid using a table in both an outer join and a regular join clause, you must divide your statement into two separate queries, or use only ANSI/ISO SQL syntax.
WHERE R.x *= S.y AND EXISTS ( SELECT * FROM T WHERE T.x = S.x )
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|