creating a temp table to do a left outer join on

See more:

SQL-Server

SQL-Server-2008

I created a query and now need to create a temporary table. It will contain the below fields. I thought I remembered how to complete this task but it doesn't run. The Query runs fine if I comment out the "IF" & "INTO" lines.
IF OBJECT_ID ('tempdb..#lstLeft') is not null drop table #lstLeft

SELECT
       SStaff.StaffName,
       PatientProviders.ProviderRole,
       SPatient.PatientName,
       Immunization.ImmunizationDateTime,
       Team.ServiceSection,
       Immunization.VisitDateTime,
       SPatient.PhoneResidence,
       SPatient.PhoneWork,
       SPatient.DateOfBirth,
       SPatient.Age,
       SPatient.Gender,
       SPatient.PatientSID
  INTO #lstLeft
  FROM /* the table and fields work fine in the query not trying to create a tempdb */