Aggregates from two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If you are trying to get aggregate information from two tables joined
together, and the relationship is one to many, how would you do it?

I have found the only way to be successful at this it to make an aggregate
query for each table that groups at the same level, then make a third query
that joins the two. Anyone have any caveats with this approach or another
approach that works?

thanks

ken
 
If you are trying to get aggregate information from two tables joined
Exactly the same as any other aggregate query. For example in NWind you
could group by the Employees address and sum the sales.

Yep, this is valid too.

I guess the answer is it depends where the grouping needs to be done to get
the desired results.
 
Back
Top