HPE NonStop SQL/MX Error – 4006 Within an aggregate, all column references must come from the same scope.

In this blog post, let’s learn about the error message “4006 Within an aggregate, all column references must come from the same scope.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4006 Within an aggregate, all column references must come from the same scope.

Reason for the Error

You referred to columns that do not come from the same scope.

Solution

Correct the column references and resubmit