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