Join two tables with additional field in one table : <p>I would like to join together two tables with additional columns.</p>

<p>First table is for number of products despatched by product</p>

<pre><code>** Table 1 - Despatches **      
Month   ProductID   No_despatched
Jan     abc          10
Jan     def          15
Jan     xyz          12
</code></pre>

<p>The second table is for the number of products returned by product, but also an additional column by return reason</p>

<pre><code>** Table 2 - Returns **     
Month   ProductID   No_returned  Return_reason
Jan     abc          2             Too big
Jan     abc          3             Too small
Jan     xyz          1            Wrong colour
</code></pre>

<p>I would like to join the tables to show returns and despatched on the same row with the number of despatched being duplicated if there are multiple return reasons for the same product.</p>

<pre><code>** Desired output **
Month   ProductID   No_despatched   No_returned   Return_reason
Jan     abc               10              2         Too big
Jan     abc               10              3         Too small
Jan     xyz               12              1         Wrong colour
</code></pre>

<p>Hope this makes sense...</p>

<p>Thanks in advance!</p>

<p>afk</p>
