title: best practice: Oracle SQL Joins
body: <p>which example below is best practice for inner joins? the examples below are
  pretty simple but, what if there are multiple tables involved? 
  which approach would you choose?</p>
  
  <p>example queries:</p>
  
  <p>simple</p>
  
  <pre><code>SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date
  FROM suppliers, orders
  WHERE suppliers.supplier_id = orders.supplier_id;
  </code></pre>
  
  <p>using keyword INNER JOIN</p>
  
  <pre><code>SELECT suppliers.supplier_id, suppliers.supplier_name, orders.order_date
  FROM suppliers
  INNER JOIN orders
  ON suppliers.supplier_id = orders.supplier_id;
  </code></pre>