title: How do I query three tables based on a single field
body: <p>I have three tables in an SQL database.  This relational system was designed by someone else but I was asked to create a new query because he no longer works for the company.  I will use sample names for confidentiality purposes.</p>
  
  <ol>
  <li><p><strong>customer</strong><br>
  customer_id<br>
  product_code<br>
  product_color<br>
  product_size<br>
  ...</p></li>
  <li><p><strong>customer_link</strong><br>
  customer_id<br>
  product_id  </p></li>
  <li><p><strong>customer_stats</strong><br>
  product_id<br>
  product_actual_product<br>
  product_actual_color<br>
  product_actual_size<br>
  ...</p></li>
  </ol>
  
  <p>This system was designed for users to enter information in the system and have multiple products for each customer.  In customer, the fields shown are all codes linked by customer_id from (1) to (2).  Two then can have multiple links between (2) and (3) based on multiple records in (2) with the same customer_id and different product_id's.  (3) has the linked product_id and the actual text for the codes listed in (1).</p>
  
  <p>The bottom line is that I need a SELECT statement based on the fields in (1) but with the data stored in (3).  Wow I'm confused and could really use some help.</p>