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 already a variable named '%1' Next Page

There is more than one way to join '%1' to '%2'


Item

Value

Constant

SQLE_AMBIGUOUS_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

-147

SQLSTATE

52W08

Sybase error code

301

Probable cause

You are attempting to KEY JOIN two tables, and there are two or more foreign keys relating the two tables. There may be two foreign keys from the first table to the second table. It may be that each table has a foreign key to the other table. You must use a correlation name for the primary key table that is the same as the role name of the desired foreign key relationship.