Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

 

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.