There is more than one way to join '%1' to '%2'
Item |
Value |
|---|---|
SQLCode |
-147 |
Constant |
SQLE_AMBIGUOUS_JOIN |
SQLState |
52W08 |
ODBC State |
42000 |
Parameter 1 |
name of first table that cannot be joined |
Parameter 2 |
name of second table that cannot be joined |
There are two or more foreign keys relating the two tables and you are attempting to KEY JOIN the two tables. Either there are two foreign keys from the first table to the second table, or 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.
