| Error 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 |
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.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |