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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

There is no way to join '%1' to '%2' Next Page

There is no way to join to '%1'


Item

Value

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.