title: How to delete matching rows in two tables in ms access?
body: <p>Here is my sql code in ms access:</p>
  
  <pre><code>DELETE Table1.*
  FROM Table1
  INNER JOIN Table2 ON Table1.Field1  = Table2.Field1
  </code></pre>
  
  <p>I want to notice here that Table1 has many columns but Table2 just one column.
  I want to delete all rows in Table1 where <code>Table1.Field1 = Table2.Field1</code>.
  But when I execute the code I get this error: Could not delete from specified tables.</p>
  
  <p>However if I use <code>SELECT</code> instead of <code>DELETE</code> it works fine for displaying rows:</p>
  
  <pre><code>SELECT Table1.*
  FROM Table1
  INNER JOIN Table2 ON Table1.Field1  = Table2.Field1
  </code></pre>
  
  <p>But I would like to DELETE these rows.</p>