title: select a value where it doesn't exist in another table
body: <p>I have two tables</p>
  
  <p>Table A:</p>
  
  <pre><code>ID
  1
  2
  3
  4
  </code></pre>
  
  <p>Table B:</p>
  
  <pre><code>ID
  1
  2
  3
  </code></pre>
  
  <p>I have two requests:</p>
  
  <ul>
  <li>I want to select all rows in table A that table B doesn't have, which in this case is row 4.</li>
  <li>I want to delete all rows that table B doesn't have.</li>
  </ul>
  
  <p>I am using SQL Server 2000.</p>