Gurus and friends

Here is a little sticking point -

I am trying to create a query which pulls in a location, a sum column for quantity, a sum column for revenue.

table1 gives the location
sum -qty comes from joins on multiple tables
sum -rev comes from joins on multiple tables

How can I ensure that a sum value is tied to location.

It's a sql puzzle that I am not able to figure out and I cannot restrict a location to a specific value.

Thanks
Hari

Oracle LazyDBA home page