title: Joining tables on foreign key
body: <p>I have the following three tables: </p>
  
  <ul>
  <li>Product</li>
  <li>Purchase (contains ProductID as foreign key)</li>
  <li>Sale (contain ProductID as foreign key as well) </li>
  </ul>
  
  <p>I want to form query joining these 3 tables where my result is the product name, purchased, and sold.</p>
  
  <p><code>Product Name</code> - (from Products table)</p>
  
  <p><code>Purchased</code> - (Number of occurences in Purchase table according to ProductID) </p>
  
  <p><code>Sold</code> -  (Number of occurences in Sale Table according to ProductID)</p>
  
  <p>Can you please set me on the right track by giving me hints and I'll complete by myself?</p>