Hi all,

i have two tables. Tab1, Tab2.

Tab1 having columns as,

itemno
distcode(A,B,C,D)

Tab2 having columns as:

itemno
total1
total2
total3
creditdate( like 01-mar-11)

Now i want the report for (A,B)distcodes as like this;

month sum(total1) sum(total2) sum(total3)
mar-2011 xxxx xxxx xxxx
apr-2011 xxxx xxxx xxxx


Please reply me soon.
Thanking you.