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

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

 

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

Error constant SQLE_CANNOT_JOIN
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of first table that cannot be joined.
Parameter 2 Name of second table that cannot be joined.
Severity 16
SQLCODE –146
SQLSTATE 53W04
Sybase error code 301
Probable cause

You may have attempted a KEY JOIN between two tables and there is no foreign key on one of the tables that references the primary key of the other table. You may have attempted a NATURAL JOIN between two tables that have no common column names.