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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Joins: Retrieving Data from Several Tables » Inner and outer joins » Transact-SQL outer joins (*= or =*)

Using views with Transact-SQL outer joins Next Page

How NULL affects Transact-SQL joins


NULL values in tables or views being joined never match each other in a Transact-SQL outer join. The result of comparing a NULL value with any other NULL value is FALSE.