如何删除不正确的语法错误 [英] How to remove incorrect syntax error

问题描述

下面我在尝试区分值时给出SQL代码然后我得到语法错误所以请帮助我



我尝试过：

Below i Give Code of SQL When I Try to Distinct Value Then i Get Syntax Error So Please Help Me

What I have tried:

SELECT distinct * FROM (  
select  Tbl_Faculty.First_Name,Designation_Master.Designation_Description,Tbl_Course_Master.Course_Name,

      Tbl_Specialisation_Master.Specialisation_Name,FacultyQualification.PassingYr,
	  Tbl_Faculty.Date_Of_Birth

 from Tbl_Faculty inner join FacultyQualification on Tbl_Faculty.Faculty_Id=FacultyQualification.FacultyId
inner join Tbl_Course_Master on FacultyQualification.CourseId=Tbl_Course_Master.Course_Id
Inner Join Tbl_Specialisation_Master on Tbl_Specialisation_Master.Course_Id=FacultyQualification.CourseId
inner Join Designation_Master on Designation_Master.DesignationID=Tbl_Faculty.Designation_Id
  where Tbl_Faculty.College_Id='406' and Availabilty_Flag= 'N'

推荐答案

结束括号）缺失

closing bracket ")" is missing

where Tbl_Faculty.College_Id='406' and Availabilty_Flag= 'N' ) 

你错过了右括号

You're missing the closing parenthesis

SELECT distinct * FROM ( 
 select Tbl_Faculty.First_Name,Designation_Master.Designation_Description,Tbl_Course_Master.Course_Name,

 Tbl_Specialisation_Master.Specialisation_Name,FacultyQualification.PassingYr,
 Tbl_Faculty.Date_Of_Birth

 from Tbl_Faculty inner join FacultyQualification on Tbl_Faculty.Faculty_Id=FacultyQualification.FacultyId
 inner join Tbl_Course_Master on FacultyQualification.CourseId=Tbl_Course_Master.Course_Id
 Inner Join Tbl_Specialisation_Master on Tbl_Specialisation_Master.Course_Id=FacultyQualification.CourseId
 inner Join Designation_Master on Designation_Master.DesignationID=Tbl_Faculty.Designation_Id
 where Tbl_Faculty.College_Id='406' and Availabilty_Flag= 'N') 

这篇关于如何删除不正确的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！