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
