I have 2 files :-

1. master file having code, itemname
2. delivery file having code, delivery date and delivery quantity

I want to display a report which should give me a report in cross tabulate form i.e.

code description jan feb mar apr ... upto dec

1 xyz item 12/jan 15 feb 3 mar
200 doz 50 doz 3500 doz

17 jan
355 doz

--------------------------------------------------------
2 zyx item.....

So the report should come monthwise merging from 2 files, currently i have written a very long procedure, which make a cursor files by using do while loops and replace.

is there any better way to do it like with select command.

Pls help !!