Collection Contents Index There is more than one way to join '%1' to '%2' Next PDF

SQL Anywhere® 10 - Error Messages  > Database Error Messages  > Alphabetic list of error messages

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.

Collection Contents Index There is more than one way to join '%1' to '%2' Next PDF