title: What is the most efficient way to write a select statement with a "not in" subquery?
body: <p>What is the most efficient way to write a select statement similar to the below.</p>
  
  <pre><code>SELECT *
  FROM Orders
  WHERE Orders.Order_ID not in (Select Order_ID FROM HeldOrders)
  </code></pre>
  
  <p>The gist is you want the records from one table when the item is not in another table.</p>