title: MS Access SQL Query - Joining 3 Tables to receive Total Order Price
body: <p>I would like to know the total price for a specific order ID. The information is contained in these tables:</p>
  
  <p>Order_line_t</p>
  
  <pre><code>Order_ID    Product_ID    Quantity
  --------    ----------    --------
  1006        4             1
  1006        5             2
  1006        7             2
  </code></pre>
  
  <p>Uses_t</p>
  
  <pre><code>Product_ID    Material_ID    Footage
  ----------    -----------    -------
  4             16             20
  5             15             13
  7             10             16
  </code></pre>
  
  <p>Raw_Materials_t</p>
  
  <pre><code>Material_ID    Unit_Price
  -----------    ----------
  16             05.70
  15             16.72
  10             15.55
  </code></pre>
  
  <p>The total cost is computed by </p>
  
  <pre><code>Multiplying SUM ( Order_line_t.Quantity * Uses_t.Footage * Raw_Materials_t.Unit_Price) AS Total
  </code></pre>
  
  <p>My current query only returns an error:</p>
  
  <pre><code>SELECT Order_line_t.Order_ID, Order_line_t.Product_ID, Uses_t.Product_ID   ,Uses_t.Footage , 
  SUM ( Order_line_t.Quantity * Uses_t.Footage * Raw_Materials_t.Unit_Price) AS Total
  FROM Order_line_t, Uses_t , Raw_Materials_t
  WHERE  Order_line_t.Order_ID = 1006;
  </code></pre>
  
  <p>Help appreciated! How exactly do I JOIN these tables? What am i missing?</p>