title: SQL - Delete rows filtered from a query result
body: <p>From this excellent post <a href="https://stackoverflow.com/a/9755787/9502397">https://stackoverflow.com/a/9755787/9502397</a> I have understood better now how to Use Join to return a list of results with similar references from different tables.</p>
  
  <p>I have that list as shown in the result after running the Select query</p>
  
  <pre><code>select 
      a.OrderDate,
      c.StaffID,
      c.Activate  
  from
      tbl_Order a
  
  join tbl_OrderDetails b
      on a.OrderID = b.OrderID
  
  join tbl_Staff c
      on b.StaffID = c.StaffID
  
  where c.Activate = 'False'
  </code></pre>
  
  <p>However, how can I use that result list and delete the those rows from tbl_Order?</p>