title: SQL Join, include rows from table a with no match in table b
body: <pre><code>SELECT orders.* FROM orders JOIN order_rows 
    ON orders.id = order_rows.order_id 
    WHERE order_rows.quant &lt;&gt; order_rows.quant_fulfilled 
    GROUP BY orders.id 
    ORDER BY orders.id DESC
  </code></pre>
  
  <p>I need this to include rows that have no corresponding order_row entries (which would be an order that has no items in it yet). It seems like there must be a way to do this by adding to the ON or WHERE clause? </p>
  
  <p>There will only be a couple empty orders at a given time so I would use a separate query if the best answer to this is going to significantly decrease performance. But I was hoping to include them in this query so they are sorted by orders.id along with the rest. Just don't want to double query time just to include the 1-3 orders that have no items.</p>
  
  <p>I am using MySQL. Thanks in advance for any advice.</p>