title: MS-Access: Selecting rows to delete via joins
body: <p>I found <a href="https://stackoverflow.com/questions/439750/t-sql-selecting-rows-to-delete-via-joins">this question</a> that is discussing what I would like to do, but it's for T-SQL. Is there a way to do something similar in Microsoft Access?  The examples below are based off what I found in that question.</p>
  
  <p>I need to delete all the records in <code>TableA</code>, which is linked to <code>TableB</code> via field <code>Bid</code> based on another field in <code>TableB</code>.</p>
  
  <p>Here is the query that selects the items to be deleted:</p>
  
  <pre><code>SELECT * 
  FROM TableA a
  INNER JOIN TableB b on b.Bid = a.Bid
  WHERE [my filter condition]
  </code></pre>
  
  <p>The following query results in an error "Specify the table containing the records you want to delete."</p>
  
  <pre><code>DELETE TableA 
  FROM TableA a
  INNER JOIN TableB b on b.Bid = a.Bid
  WHERE [my filter condition]
  </code></pre>
  
  <p>Is this possible with an Access query?</p>