Invalid expression in WHERE clause of Transact-SQL outer join

Probable cause 

An expression in the WHERE clause of a query which uses Transact-SQL syntax contains a comparison of a column from the null-supplying table with a subquery or an expression which references a column from another table.