Alphabetic list of error messages
900
There is more than one way to join ’%1’ to ’%2’
Item Value
SQLCODE -147
Constant SQLE_AMBIGUOUS_JOIN
SQLSTATE 52W08
Sybase error code 301
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.
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
which is the same as the role name of the desired foreign key relationship.
There is no way to join ’%1’ to ’%2’
Item Value
SQLCODE -146
Constant SQLE_CANNOT_JOIN
SQLSTATE 53W04
Sybase error code 301
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.
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.
Probable cause
Probable cause