title: Selecting specific rows from table
body: <p>I have the below table (in picture) which is kind of inventory table and shows how many items comes in and how many goes out from stock, and <strong>item_id</strong> is the foreign key from another table.</p>
  
  <p>I want to select those records that has no <strong>out</strong> from the stock, in other word i want to select those records which are highlighted in green (in the picture).</p>
  
  <p>Thanks.</p>
  
  <p><strong>Sorry for poor English</strong></p>
  
  <p>The Table</p>
  
  <p><img src="https://i.stack.imgur.com/2kr81.jpg" alt="enter image description here"></p>