Error 680

"Invalid expression in WHERE clause of Transact-SQL outer join"

Item Description

SQLCode

-680L

Constant

INVALID_TSQL_OJ_EXPRESSION

SQLState

52W23

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2307

Severity Code

16

Probable cause

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


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com