Data fetch with join from 5 SQL Server tables, how to do it right?

Question

SQL Server

Hello!
Can you please tell me how to correctly write a query for data sampling, where there is a condition for joining 5 tables?

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 BaseLearningPlan.BaseLearningPlanID = BaseLearningPlan.SpecialtyID			
      JOIN SpecialtyInfo
      ON SpecialtyInfo.SpecialtyID = SpecialtyInfo.specialtyID			
      JOIN FacultyInfo 
      ON FacultyInfo.FacultyID = FacultyInfo.FacultyID
            
      --где ID факультета пользователя =
      SELECT FacultID FROM UsersBD WHERE UsersID = 20

Answer 1

ok google, transact sql join syntax

Answer 2

Solution:

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