Re: embedded SQL: group by rollup()

[Booth Martin <booth@xxxxxxxxxxxx>]

L1, L2, L3 are values to be found in LOC.

I am attempting to total the ORD column, by LOCation.  I want the total 
order quantity for each of 3  warehouse LOCations.

I had originally used a cursor.  The examples I found appeared to not 
use a cursor, so I took it out.

Yes, I agree.  I am putting all the values in one bucket.  Thats not 
right, but every thing else I have tried so far is even less right.  I 
haven't yet found an example that is complete from end to end.

On 1/18/2016 3:02 PM, Michael Schutte wrote:
> are L1, L2 and L3 fields in FILEA?
>
> If so add them to the Select and group by....