title: Could not delete from specified tables
body: <p>I need to delete all the data from Table1 that has a corresponding ID in Table2. I used:</p>
  
  <pre><code>DELETE Table1.*
  FROM Table1 INNER JOIN Table2 ON Table1.ID=Table2.ID
  </code></pre>
  
  <p>I ran it and got an error message "Could not delete from specified tables"</p>
  
  <p>I also tried some suggestion I found here and changed the query to</p>
  
  <pre><code>DELETE Table1.*
  FROM Table1 INNER JOIN Table2 ON Table2.ID=Table1.ID
  </code></pre>
  
  <p>But got the same eerror</p>