title: Display records from two tables side by side matching only some of the fields
body: <p>I have two tables, <code>table A</code>:</p>
  
  <pre><code>Customer_ID  Product  Date Of Sale  Pay Meth 1  Pay Meth 2  QTY
  -----------  -------  ------------  ----------  ----------  ---
          123  AB       1/1/2012             111         222    1
          123  AB       1/1/2012             111         222    1
          456  AC       2/1/2012             333         444    1
  </code></pre>
  
  <p>and <code>table B</code>:</p>
  
  <pre><code>Customer_ID  Product  Date Of Sale  Pay Meth 1  Pay Meth 2  QTY
  -----------  -------  ------------  ----------  ----------  ---
          123  AB       1/1/2012             111         222    2
          456  AB       1/1/2012             124         111    1
  </code></pre>
  
  <p>I want to match the data up so that the record for customer <code>123</code> in <code>table A</code> is grouped as :</p>
  
  <pre><code>Customer_ID  Product  Date Of Sale  Pay Meth 1  Pay Meth 2  QTY
  -----------  -------  ------------  ----------  ----------  ---
          123  AB       1/1/2012             111         222    2
  </code></pre>
  
  <p>and to the right of it appears the following record from <code>table B</code>:</p>
  
  <pre><code>Customer_ID  Product  Date Of Sale  Pay Meth 1  Pay Meth 2  QTY
  -----------  -------  ------------  ----------  ----------  ---
          123  AB       1/1/2012             111         222    2
  </code></pre>
  
  <p>Also (there is always an also) we want to show the third record in <code>table A</code> and to the right of that record the second record in <code>table B</code> (customer <code>456</code>) because they Have the same <code>Customer_ID</code>, <code>Product</code> and <code>Date of Sale</code></p>
  
  <p>So it should look something like </p>
  
  <pre><code>Customer_ID  Product  Date Of Sale  Pay Meth 1  Pay Meth 2  QTY  Customer_ID  Product  Date Of Sale  Pay Meth 1  Pay Meth 2  QTY
  -----------  -------  ------------  ----------  ----------  ---  -----------  -------  ------------  ----------  ----------  ---
          123  AB       1/1/2012             111         222    1          123  AB       1/1/2012             111         222    1
          456  AC       2/1/2012             333         444    1          456  AB       1/1/2012             124         111    1
  </code></pre>