title: SQL Delete Rows Based on Another Table
body: <p>This is probably very easy, but it's Monday morning.  I have two tables:</p>
  
  <p>Table1:</p>
  
  <pre><code>Field        | Type             | Null | Key | Default | Extra
  id           | int(32) unsigned | NO   | PRI | NULL    | auto_increment
  group        | int(32)          | NO   |     | 0       |                
  </code></pre>
  
  <p>Table2:</p>
  
  <pre><code>Field     | Type             | Null | Key | Default | Extra
  group     | int(32)          | NO   |     | 0       | 
  </code></pre>
  
  <p>Ignoring other fields...I would like a single SQL DELETE statement that will delete all rows in Table1 for which there exists a Table2.group equal to Table1.group. Thus, if a row of Table1 has group=69, that row should be deleted if and only if there exists a row in Table2 with group=69.</p>
  
  <p>Thank you for any help.</p>