title: How to remove row that exists in another table?
body: <p>I have two tables. Main table is "CompleteEmailListJuly11" and the second table is "CurrentCustomersEmailJuly11". I want to delete rows in CompleteEmailListJuly11 table that CurrentCustomersEmailJuly11 has based off email.</p>
  
  <p>I've tried this following Delete example, but it doesn't do anything close to what I'm trying to do. This only shows me the ones that EXIST in the database, it doesn't show me the the list of emails that AREN'T matching.</p>
  
  <pre><code>DELETE * FROM CompleteEmailListJuly11 AS i 
  WHERE EXISTS ( 
      SELECT 1 FROM CurrentCustomersEmailJuly11 
      WHERE CurrentCustomersEmailJuly11.email = i.EmailAddress
  )
  </code></pre>
  
  <p>Help is greatly appreciated.</p>