SQL Server 2008 - How to Join 3 Tables

Question

SQL Server 2008:

I have 3 tables

Users, Scores, Lessons 

Users and Scores linked by StudentID

Scores and Lessons related LessonID

I want to display grades for StudentID . Here are the columns I want to display

 Users.Name, Scores.LessonID, Scores.Result, Lessons.Title 

I know how to join 2 tables. How can I add a third table?

Answer 1

Same as one table:

 SELECT Users.Name, Scores.LessonID, Scores.Result, Lessons.Title FROM Users INNER JOIN Scores ON Users.StudentID = Scores.StudentID INNER JOIN Lessons On Scores.LessonID = Lessons.LessonID 

Answer 2

  SELECT * FROM T1 INNER JOIN T2 ON T2.C = T1.C INNER JOIN T3 LEFT JOIN T4 ON T4.C = T3.C ON T3.C = T2.C is equivalent to (T1 Inner Join T2) Inner Join (T3 Left Join T4)