Incorrect Syntax near "as"

Nov 4 2014 5:08 AM
"Select Appointment.Time as Time,Appointment.Date As Date, (Select Dept_Name From Department Where Department.Dept_Id=Appointment.Dept_Id) As Dept,(Select Staff_Name From staff_name Where staff_name.Staff_Id=Appointment.Staff_Id )As Doctor" +
  "(Select Pnt_Name From Patient_Reg Where Patient_Reg.Patient_Id = Appointment.Patient_Id) as Name FROM Appointment";

In it, show an error "Incorrect syntax near 'as' ". Please Suggest me correct syntax

  thank you

Answers (3)