title: How to exclude row if field exists in another table? (SQL Server)
body: <p>I am having trouble excluding a row in a query if a certain field in that row exists in another table.</p>
  
  <p>For example, </p>
  
  <p><code>SELECT column1, column2</code></p>
  
  <p><code>FROM Table1</code></p>
  
  <p>And let's say it results out to</p>
  
  <pre><code>**column1**      **column2**
     Name1            Name2 
  </code></pre>
  
  <p>Then in Table2, there is also a column1 and it has Name1 value as well.</p>
  
  <p>How would I edit my first query to check Table2 and if it has Name1 under column1 as well, then exclude the whole row? </p>
  
  <p>Thank you for any assistance!</p>