Filter
Top Products
A common error with this method of manipulating data is that the user may mistakenly believe that obtaining the totals
of STOCKQTY and ORDERQTY for each ITMNO will provide the same result as in Example 1. The following is an
example of using this method incorrectly:
Example 2:
In this example, the data manipulation used in Example 1 is incorrectly specified.
Figure: Example of a common error when grouping multiple joined tables shows the result of the execution of this
query specification.
83