sql required

[subs]

ozip dzip sum of wgt sum of paid amt year
a b 2000 2333 2009
a b 33 444 2008
c d 44 3333 2009
x y 33 33333 2009
x y 222 2222 2008


output required - Pls note i require the second row also


ozip dzip total wgt 2009 total wgt2008 sum of paid amt 2009
sum of paid amt 2008
a b 2000 33
2333 444
c d 44 3333
x y 33 222
33333 2222


what should be sql query - pls help thanks

 

[Stefan Hoffmann]

hi,

what should be sql query - pls help thanks

Looks like a pivot query. Take a closer look at the wizard after
pressing the "new query" button...



mfG
--> stefan <--