title: Accurate results joining 2 tables
body: <p>Table A lists an item and the number of pieces that must go through each of the 4 possible stations.</p>
  
  <pre><code>Item      To Cut      To Paste      To Laminate      To Ship
  Box          9            9              5              9
  Cart         1            0              10             10
  </code></pre>
  
  <p>Table B lists the number of pieces that have been processed through each of the stations.</p>
  
  <pre><code>Item      Cut Done      Paste Done      Laminated      Shipped
  Box          9            0                0             0
  Box          0            9                0             0
  Box          0            0                5             0
  Box          0            0                0             9
  </code></pre>
  
  <p>When I join them it shows:</p>
  
  <pre><code>Item      To Cut      Cut Done      To Paste      Paste Done
  Box          36          9             36             9
  </code></pre>
  
  <p>This is because of the way Table B works. How can I get it to accurately show the total To Cut and Cut Done in one table so percentages are correct?</p>
  
  <p>My query is:</p>
  
  <pre><code>select a.item, a.to_cut, a.to_paste, a.to_laminate, a.to_ship, b.cut_done, b.paste_done, b.laminated, b.shipped
  
  from ToDo a join Done b on a.item = b.item
  </code></pre>