title: mysql two table join sum not equal result
body: <p>I have two tables <code>purchase_orders_details</code> and <code>stock_orders_details</code> I show in below of my paragraph</p>
  
  <pre><code>purchase_orders_details
  
  --------------------
  item_id | item_qty |
  --------------------
  |   1   |    15    |
  |   2   |    10    |
  |   1   |    20    |
  --------------------
  
  stock_orders_details
  ------------------------
  item_id | item_rcv_qty |
  ------------------------
  |  1 |       10        |
  |  2 |        5        |
  |  1 |       15        |
  ------------------------
  </code></pre>
  
  <p>The query example is:</p>
  
  <pre><code>SELECT * FROM purchase_orders_details p 
  left join stock_details d on p.item_qty=d.item_rcv_qty 
  WHERE d.item_rcv_qty IS NULL
  </code></pre>
  
  <p>I want to result like this, and only result show who not matched with <code>item_qty not equal item_rcv_qty</code> because when both quantity is equal then order will be completed.</p>
  
  <pre><code>-------------------------------------------------
  Item Id  | Item Quantity  |  Received Quantity |
  -------------------------------------------------
  |   1    |   35           |      25            |
  |   2    |   10           |       5            |
  -------------------------------------------------
  </code></pre>