Error 146

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

Item Description

SQLCode

-146L

Constant

CANNOT_JOIN

SQLState

53W04

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2086

Severity Code

16

Parameter 1

Name of first table that cannot be joined.

Parameter 2

Name of second table that cannot be joined.

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.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com