Please see my other Database Development articles.
Performing a subquery while Sum-ming a column
In this article I will demonstrate how to use a subquery with SUM() to return parent records and related child records while aggregating currency amounts.
First, I’ll start with a a couple customer records, each with two order records with a total.
Next, I’ll return the same customer records, each with a grant total of their order total from their order records.