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
