HPE NonStop SQL/MX Error – 4004 Column name name1 is ambiguous. Tables in scope: names. Default schema:name2.

Data 25 Views 1 Min Read

In this blog post, let’s learn about the error message “4004 Column name name1 is ambiguous. Tables in scope: names. Default schema:name2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4004 Column name name1 is ambiguous. Tables in scope: names. Default schema:name2.

Reason for the Error

You referenced column name1 , whose parent table is ambiguous. The table names or tables in the scope of the column reference and default schema name2 appear.

Solution

Correct the syntax so that the table’s parent table is clear, and resubmit

Tags: