ASA SQL User's Guide
Joins: Retrieving Data from Several Tables
Inner and outer joins
Transact-SQL outer joins (*= or =*)
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.