HPE NonStop SQL/MX Error – 4003 Column name1 is not a column in table name2, or, after a NATURAL JOIN or JOIN USING, is no longer allowed to be specified with a table correlation name.

In this blog post, let’s learn about the error message “4003 Column name1 is not a column in table name2, or, after a NATURAL JOIN or JOIN USING, is no longer allowed to be specified with a table correlation name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4003 Column name1 is not a column in table name2, or, after a NATURAL JOIN or JOIN USING, is no longer allowed to be specified with a table correlation name.

Reason for the Error

You either attempted to select column name1 , which does not exist, or referenced a column that is included in a NATURAL JOIN or JOIN USING and is now a common column. If a column is part of a JOIN operation, you no longer qualify its name with its original table name2 .

Solution

Correct the syntax and resubmit. If the column is part of a JOIN, remove the table qualifier and use only the column name