title: How do I build a query that crosses multiple tables?
body: <p>Here are my tables:</p>
  
  <p><strong>CUSTOMER</strong></p>
  
  <pre><code>Cust_ID (PK)
  Name
  </code></pre>
  
  <p><strong>ORDERS</strong></p>
  
  <pre><code>Order_ID (PK)
  Cust_ID (FK)
  </code></pre>
  
  <p><strong>ORDER_LINE</strong></p>
  
  <pre><code>Order_ID (pk)
  Part_ID (FK)
  </code></pre>
  
  <p><strong>PART</strong></p>
  
  <pre><code>Part_ID (PK)
  Part_Description
  </code></pre>
  
  <p>Now I want to list the customer details, the part number and the description of the parts that each customer ordered.</p>
  
  <p>How do i do this?</p>
  
  <p>Thanks.</p>