There is no way to join to '%1'

Error constant	SQLE_CANNOT_JOIN_TABEXPR
ODBC 2 state	37000
ODBC 3 state	42000
Parameter 1	Name of table or view that cannot be joined.
Severity	15
SQLCODE	-875
SQLSTATE	42W73
Sybase error code	102

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.

Discuss this page in DocCommentXchange.