Joining tables on foreign key
<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>