title: join table more than once in the same query?
body: <p>I'm looking for some help on constructing a query. I have three tables like this:</p>
  
  <pre><code>Products
  
  id    |   (20 other columns I don't need)
  1
  
  product_names
  
  product_id    |    product_name
  1                  my product
  2                  my second product
  3                  my third product
  
  cross_sell_products (where each product may have one, two, or no cross sell products)
  
  product_id    |    cross_sell_product_id
  1                  2
  1                  3
  </code></pre>
  
  <p>I'm looking to use a single query that will give me a list of all products (with their names), and each of their cross-sell product names. </p>
  
  <p>The problem is, all this information is coming from the product_names table, and I'm not sure how to perform a join more than once on the same table, within the same query. (Hope that make sense!)</p>
  
  <p>So the output would be something like:</p>
  
  <pre><code>id    |    product_name    |    cross_sell_product_1    |    cross_sell_product_2
  1          my product           my second product            my third product
  </code></pre>
  
  <p>Appreciate any help with this!</p>