title: How to join three tables in sql server
body: <p>I have three tables:</p>
  
  <ul>
  <li>Chapter (ChapterNo, Desc)</li>
  <li>Lesson (LessonNO, Dec, ChapterNo)</li>
  <li>Case (CaseNo, Desc, LessonNo)</li>
  </ul>
  
  <p>As you see, the three tables are all connected. What I want is to return all the chapters (even without lessons in it), all the lessons (even without cases in it) and all the cases.</p>
  
  <p>I am sorry to say but I really don't have an idea so I have no sample code. I hope my explanations are enough.</p>