HPE NonStop SQL/MX Error – 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.

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