title: Delete query in SQL (Access) in conjuction with dependent data?
body: <p>I know this is a very basic question but I am unable to get it done. Just started to learn more about databases. I have two tables: tblFoodAllowance and tblTravelDays.</p>
  <p>tblFoodAllowance consists of ID, tripID, dateDay, costs.
  tblTravelDay saves all days when I was on a business trip: ID, dateDay.</p>
  <p>I am looking for a delete query in SQL to use in MS Access which does this: Delete all from tblFoodAllowance where tripID is xy (e.g. 1) and tblFoodAllowance.dateDay is not in the list of tblTravelDates. How can I achieve this?</p>
  <p>I tried multiple things but either I got a syntax error or a wrong result. Thanks for your help.</p>
  <p>I guess it is something like:</p>
  <pre><code>DELETE * FROM tblFoodAllowance WHERE tblFoodAllowance.tripID = [tripID] and ()
  </code></pre>