Incorrect Syntax near as

Question

Select Appointment.Time as TimeAppointment.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

Joginder Banger · Answer

hi Priti Srivastava  as per your problem i can understand you are write this query in .cs (page) just remove the +(plus) sign or put the comma after doctor.

Vulpes · Answer

I don't know which SQL database you're using but it's possible that identifiers such as date time and name are reserved words in that particular dialect. See if it makes any difference if you place all those words in square brackets e.g [DATE] instead of [DATE]. I'd also place a comma immediately after DOCTOR.

Dipankar Biswas · Answer

hi..... see this link.. http://stackoverflow.com/questions/8654075/incorrect-syntax-near-the-keyword-as-in-sql-server

Incorrect Syntax near "as"