Error 875

"There is no way to join to '%1'"

Item Description

SQLCode

-875L

Constant

CANNOT_JOIN_TABEXPR

SQLState

42W73

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2527

Severity Code

15

Parameter 1

Name of table or view that cannot be joined.

Probable cause

The server cannot discover a valid join condition involving this table. If the join is an outer join, you may be missing an ON clause. If the join is a KEY JOIN, the server cannot discover a foreign key-primary key relationship with this table that can be used to generate the join condition. If the join is a NATURAL JOIN, the table has no common column names with the table expression it is being joined to.


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