This may be simple and I just can't see it, but, here goes.

I will simplify this as much as possible.

Table name: TABLE

ITEM LOCATION QTY
ABC 100 20
ABC 102 10
ABC 100 15
ABC 101 30
ABC 102 12

I know how to SUM and GROUP BY which will give me 3 rows (one for each
location). But is there a statement that will return 1 row like this:

ITEM LOCATIION 100 QTY LOCATION 101 QTY LOCATION
102 QTY
ABC 35
30 22

Any help is much appreciated.

DG