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
