Error 680

Message text

Invalid expression in WHERE clause of Transact-SQL outer join

Item

Value

SQLCode

-680

Constant

SQLE_INVALID_TSQL_OJ_EXPRESSION

SQLState

52W23

ODBC State

42000

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.