How to join this 2 result sets

See more:

SQL-Server

SQL-Server-2008

From_Month	From_Year	From_Date       To_Date	   From_Month_Desc
1	         2011	         3-Jan-11	31-Jan-11	Jan
2	         2011	         1-Feb-11	28-Feb-11	Feb
3	         2011	         1-Mar-11	31-Mar-11	Mar
4	         2011	         1-Apr-11	30-Apr-11	Apr
5	         2011	         1-May-11	31-May-11	May
6	         2011	         1-Jun-11	30-Jun-11	Jun
7	         2011	         1-Jul-11	31-Jul-11	Jul
8	         2011	         1-Aug-11	31-Aug-11	Aug
9	         2011	         1-Sep-11	30-Sep-11	Sep
10	         2011	         1-Oct-11	31-Oct-11	Oct
11	         2011	         1-Nov-11	30-Nov-11	Nov
12	         2011	         1-Dec-11	31-Dec-11	Dec
1	         2012	         1-Jan-12	31-Jan-12	Jan
2	         2012	         1-Feb-12	29-Feb-12	Feb
3	         2012	         1-Mar-12	31-Mar-12	Mar
4	         2012	         1-Apr-12	30-Apr-12	Apr
5	         2012	         1-May-12	31-May-12	May
6	         2012	         1-Jun-12	30-Jun-12	Jun

This is my Proj Start Date & End Date details result set....

Fun_Code	Short_Desc	Fun_Desc	Plan_Month	Plan_Year	 Date_	   Qty
41849	           2	       STOCK HOUSE	        1	2011	        Jan-11	   25
41852	           2	       SH DEDUSTING	        1	2011	        Jan-11	   30
41853	           3	       HOT STOVE	        1	2011	        Jan-11	   32
41853	           3	       HOT STOVE	        2	2011	        Feb-11	   50
41849	           2	       STOCK HOUSE	        6	2012	        Jun-12	   200

This is my Qty result set,

every month we planned some material quantities...

now what i want is each and every material i want to display the total proj months if any month i enter qty , that col alone to display that details...

I want to merge that 2 result sets...



How to do this