title: Joins Specific Querying
body: <p>I'm using SQL Server 2017 and I have a question on how to return specific values (I'm not sure 100% if I should be using joins or subqueries.) I tried to put an example below of what I'm trying to do and hopefully someone can help me out with this.</p>
  <p>I have two tables below:</p>
  <p>Table 1</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Record</th>
  <th>Topic</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>100</td>
  <td>History</td>
  </tr>
  <tr>
  <td>101</td>
  <td>Science</td>
  </tr>
  <tr>
  <td>102</td>
  <td>Art</td>
  </tr>
  <tr>
  <td>103</td>
  <td>Music</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table 2</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Record</th>
  <th>Course</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>100</td>
  <td>Intro</td>
  </tr>
  <tr>
  <td>100</td>
  <td>Intermediate</td>
  </tr>
  <tr>
  <td>101</td>
  <td>Intermediate</td>
  </tr>
  <tr>
  <td>101</td>
  <td>Advanced</td>
  </tr>
  <tr>
  <td>102</td>
  <td>Intro</td>
  </tr>
  <tr>
  <td>102</td>
  <td>Intermediate</td>
  </tr>
  <tr>
  <td>103</td>
  <td>Intermediate</td>
  </tr>
  <tr>
  <td>103</td>
  <td>Advanced</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to join the two tables together, but only bring back the columns 'Record' and 'Topic' ONLY where the Record DOES NOT have an 'Intro' course attached to it.</p>
  <p>So I would want to bring back the following results (since both Courses do not have an Intro class):</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Record</th>
  <th>Topic</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>101</td>
  <td>Science</td>
  </tr>
  <tr>
  <td>103</td>
  <td>Music</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>So far I've had no luck and am bringing back more records than I should so any help or guidance would be appreciated. Thank you in advance.</p>