title: SQL server join query to get all subjects
body: <p>I have the three tables:</p>
  
  <p><code>TBL_SUBJECT</code>, <code>TBL_SEMESTER</code> and <code>TBL_SUBJECT_SEMESTER_MAPPING</code></p>
  
  <p>I am having <code>subjectId</code> with me say '1', I want to get All the subjects of the semester to which my subject belongs. i.e subject having Id '1'.</p>
  
  <p>How is the query with joins in SQL server.</p>