title: Multiple Tables - Lowest Value based on Where clause
body: <p>Currently have 3 tables with the following columns,</p>
  
  <pre><code>Table 1
  item_id | cost_price
  
  Table 2 
  item_id | cost_price
  
  Table 3
  item_id | cost_price
  </code></pre>
  
  <p>Need to sort by lowest value between the three tables where the clause is to sort by the item_id. The item_id is shared between all 3 tables.</p>
  
  <p>I know its probably a subquery, with a INNER join? But I'm just not sure how to write it...</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT table1.cost_price, table2.cost_price, table3.cost_price FROM table2
  INNER JOIN table1
  ON table1.item_id= table2.item_id
  INNER JOIN table3
  ON table3.item_id= table1.item_id
  </code></pre>
  
  <p>I'm hoping to sort by the lowest cost_Price out of the query.. But I'm not sure if I should use inner join..</p>