In this blog post, let’s learn about the error message “4135 In an INSERT-SELECT, each column in the ORDER BY clause must be one of the columns in the selected list of the query. Column in error: B.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4135 In an INSERT-SELECT, each column in the ORDER BY clause must be one of the columns in the selected list of the query. Column in error: B.
Reason for the Error
You tried to SQL-compile an INSERT-SELECT statement that specified an ORDER BY column that is not in the select list of the query.
Solution
Omit the ORDER BY clause or specify an ORDER BY column that is also in the select list of the INSERT-SELECT query and resubmit
