TSD3006: The relationship from {referencing object} cannot be resolved between the following possible identifiers: {list of options}.
This error occurs when more than one possibility exists for the relationship between objects.
To correct this error
- Fully qualify the object reference that is ambiguous, and save the updated object definition.
Example
This error appears if you try to create a view that is named v1, when you have the following object definitions:
CREATE TABLE t1 (int c1, int c2)
CREATE TABLE t2 (int c1, int c2)
CREATE VIEW v1 AS SELECT c1 FROM t1,t2
In this case, to resolve the error, you might change the definition for v1 to the following:
CREATE VIEW v1 AS SELECT t1.c1 FROM t1,t2