How to remove incorrect syntax error

Question

1.00/5 (3 votes)

See more:

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:

SQL

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'

Posted 9-Sep-16 0:26am

Member 12183079

Updated 9-Sep-16 2:49am

Maciej Los

v2

Add a Solution

Comments

Maciej Los 9-Sep-16 8:50am

What is exact error message?
What database?

Note: we don't see your screen and we can't read in your mind!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2016-09-09T00:31:00

Solution 1

closing bracket ")" is missing

SQL

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

Posted 9-Sep-16 0:31am

Karthik_Mahalingam

Comments

Member 12183079 9-Sep-16 6:35am

No Still Remain Error

Karthik_Mahalingam 9-Sep-16 6:38am

error message?

F-ES Sitecore · Answer 2 · 2016-09-09T00:31:00

You're missing the closing parenthesis

SQL

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')