Sql query..Need put in Temp Table
Hello I need the additional parts an the sql query below as follows:
 1. Put results of below query into a #temp Table (temp name 'mytemp')
  Select (c.First_Name + ' ' + c.Last_Name) AS Auditor_Name,d.Office_Name, a.Firm_Name,e.Country_Abbr,COUNT(Conf_Req_ID) Number from Accounting_Firm a,Accountant b,Users c,Firm_Office d,Country e, Confirmation_Request f Where a.Firm_ID = b.Firm_ID and b.User_ID = c.User_ID and b.Office_ID = d.Office_ID and e.Country_ID = d.Office_Country_ID and f.Accountant_ID = b.Accountant_ID and e.Country_Abbr Like 'UK' Group By c.First_Name,c.Last_Name,d.Office_Name,a.Firm_Name, e.Country_Abbr 2. With another sql query 'Join' the temp table and another table ('billing' that has a year column)

 get the results to be as follows: Auditor_Name Office_Name Firm_Name Country_Abbr Number Year
 2. I need 3 queries....1. for the year 2009, 2. for the year 2010, 3.for the yesr 2011 
Sql query..Need put in Temp Table
===

Hello I need the additional parts an the sql query below as follows:
 1. Put results of below query into a #temp Table (temp name 'mytemp')
  Select (c.First_Name + ' ' + c.Last_Name) AS Auditor_Name,d.Office_Name, a.Firm_Name,e.Country_Abbr,COUNT(Conf_Req_ID) Number from Accounting_Firm a,Accountant b,Users c,Firm_Office d,Country e, Confirmation_Request f Where a.Firm_ID = b.Firm_ID and b.User_ID = c.User_ID and b.Office_ID = d.Office_ID and e.Country_ID = d.Office_Country_ID and f.Accountant_ID = b.Accountant_ID and e.Country_Abbr Like 'UK' Group By c.First_Name,c.Last_Name,d.Office_Name,a.Firm_Name, e.Country_Abbr 2. With another sql query 'Join' the temp table and another table ('billing' that has a year column)

 get the results to be as follows: Auditor_Name Office_Name Firm_Name Country_Abbr Number Year
 2. I need 3 queries....1. for the year 2009, 2. for the year 2010, 3.for the yesr 2011 