title: Delete records from multiple tables in Access 2007
body: <p>Using the following data, I am attempting to delete matching records from both tables.</p>
  
  <p>Fruits</p>
  
  <p>ID  Value<br>
  1   Apple<br>
  2   Pear<br>
  3   Banana<br>
  4   Grape</p>
  
  <p>Animals</p>
  
  <p>ID  Value<br>
  1   Bear<br>
  2   Monkey<br>
  3   Apple<br>
  4   Pig</p>
  
  <p>There is no defined relationship between these two tables.</p>
  
  <p>Since "Apple" appears in both tables, I would like to remove this record from each of them.</p>
  
  <p>I've tried the following query to accomplish this:</p>
  
  <pre><code>DELETE DISTINCTROW Animals.*, Fruits.*
  FROM Animals INNER JOIN Fruits ON Animals.Value = Fruits.Value;
  </code></pre>
  
  <p>However, when I run this, I receive the following error:</p>
  
  <blockquote>
    <p>Could not delete from specified tables.</p>
  </blockquote>
  
  <p>What am I doing wrong, and what can I do to fix this?</p>