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 more than one way to join '%1' to '%2' Next Page

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


Item

Value

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.