Urgent:Reply for the output in the form of SQL Script?

Question

PID	ProductDesc	ProductCode
1	Packet-Eye	P001
2	Wiggy	W099
3	Wimax-Lite	W001
4	Wimax-Home	W002

 Table1

 

The table1 above  contains 20 Rows 

 

 

Date	PID
1/14/2009	1
1/15/2009	1
2/1/2009	2
3/3/2009	3

Table 2

 

Table2 contains above 80,000 Rows

 

 

 

Output1 needed is:

Product	Jan 2009	Feb 2009	March 2009	April 2009	May 2009	June 2009	July 2009
Packet Eye	100	67	87	51	30	90	40
Wiggy	300	200	150	20	70	12	100
Wimax-lite	40	59	70	60	100	20	10
----	---	---	---	-----	----	-----	-----

 

Using Table1 and Table2, construct 2 separate SQL scripts to derive the output illustrated  Output 1