title: SQL SELECT FIELDS IN A DIFFERENT TABLE
body: <p>I have two tables, one called orders and the other one is invoices. I want to know if I have a closed order without an invoice.  they're joined by id_order, so I have this. </p>
  
  <pre><code>select  I.ID_Order,O.ID_order from Invoices I
  inner join Orders O on o.ID_Order = I.ID_Order
  where o.Status='x'
  </code></pre>
  
  <p>if o.iD_order is found in invoices that means the order is invoiced.
  if o.id_order is not found in invoices that means its not invoiced. </p>
  
  <p>I want to get in the select statement all of the orders that are not invoiced.</p>