Выборка данных с объединением из 5 таблиц - SQL Server

[Demonikaliysis]

Здравствуйте!
Подскажите пожалуйста как правильно записать запрос для выборки данных, где есть условие объединения 5 таблиц?

--*************************************************************
            --факультет
 
            --Выбрать все записи факультета пользователя
            SELECT StatementID, StatementNumber, FlagMain, StudentID, DateCreate, 
            MarkValue, AcademHours, teacher1ID, teacher2ID, teacher3ID, WorkLPSubjectID 
            FROM 
            [Statement],WorkLPSubjects,BaseLearningPlan,SpecialtyInfo,FacultyInfo
            
            [Statement] JOIN WorkLPSubjects
            ON [Statement].WorkLPSubjectID = WorkLPSubjects.WorkLPSubjectID,
            
            WorkLPSubjects JOIN BaseLearningPlan 
            ON WorkLPSubjects.BaseLearningPlanID = BaseLearningPlan.SpecialtyID,
            
            BaseLearningPlan JOIN SpecialtyInfo 
            ON BaseLearningPlan.SpecialtyID = SpecialtyInfo.specialtyID,
            
            SpecialtyInfo JOIN FacultyInfo
            ON SpecialtyInfo.FacultyID = FacultyInfo.FacultyID
            = 
            --Сообщение 102, уровень 15, состояние 1, строка 16
            --Неправильный синтаксис около конструкции "=".
                        
            --где ID факультета пользователя =
            (SELECT FacultID FROM UsersBD WHERE UsersID = 20)
--************************************************************

[evg_m]

SELECT StatementID, StatementNumber, FlagMain, StudentID, DateCreate, MarkValue, AcademHours, teacher1ID, teacher2ID, teacher3ID, WorkLPSubjectID
FROM  [Statement],WorkLPSubjects,BaseLearningPlan,SpecialtyInfo,FacultyInfo

WHERE 
     [Statement].WorkLPSubjectID = WorkLPSubjects.WorkLPSubjectID
and  WorkLPSubjects.BaseLearningPlanID = BaseLearningPlan.SpecialtyID
and  BaseLearningPlan.SpecialtyID = SpecialtyInfo.specialtyID
and  SpecialtyInfo.FacultyID = FacultyInfo.FacultyID

AND --где ID факультета пользователя 
       ... in (SELECT FacultID FROM UsersBD WHERE UsersID = 20)

SELECT StatementID, StatementNumber, FlagMain, StudentID, DateCreate, MarkValue, AcademHours, teacher1ID, teacher2ID, teacher3ID, WorkLPSubjectID
FROM  [Statement]
INNER JOIN WorkLPSubjects    ON [Statement].WorkLPSubjectID = WorkLPSubjects.WorkLPSubjectID
INNER JOIN BaseLearningPlan  ON WorkLPSubjects.BaseLearningPlanID = BaseLearningPlan.SpecialtyID
IINER JOIN SpecialtyInfo     ON BaseLearningPlan.SpecialtyID = SpecialtyInfo.specialtyID 
INNER JOIN FacultyInfo       ON SpecialtyInfo.FacultyID = FacultyInfo.FacultyID

WHERE --где ID факультета пользователя 
       ... in (SELECT FacultID FROM UsersBD WHERE UsersID = 20)

[Demonikaliysis]

Я дико извиняюсь, но как записать чтобы выполнялся внутренний запрос после основного запроса?
Пробовал по-разному не получилось их связать вместе, всегда синтаксическую ошибку выдаёт.

[Demonikaliysis]

Решение проблемы:

SELECT DISTINCT StatementID, StatementNumber, FlagMain, StudentID, DateCreate, MarkValue, AcademHours, 
                          teacher1ID, teacher2ID, teacher3ID, WorkLPSubjects.WorkLPSubjectID
			FROM [Statement] JOIN WorkLPSubjects
			ON [Statement].WorkLPSubjectID = WorkLPSubjects.WorkLPSubjectID
							 JOIN BaseLearningPlan
			ON WorkLPSubjects.BaseLearningPlanID = BaseLearningPlan.BaseLearningPlanID
							 JOIN SpecialtyInfo
			ON BaseLearningPlan.SpecialtyID = SpecialtyInfo.specialtyID
							 JOIN FacultyInfo
			ON SpecialtyInfo.FacultyID = FacultyInfo.FacultyID
							 JOIN UsersBD
			ON FacultyInfo.FacultyID = UsersBD.FacultID
			
			WHERE UsersID = 20