title: How to join multiple tables in MySQL?
body: <p>I want to see what customers ordered what from a given manufacture.</p>
  
  <p>I have theses tables (with columns):</p>
  
  <ul>
  <li>items (item_num, <strong>order_num</strong>, stock_num, <strong>manu_code</strong>, quantity, etc.)</li>
  <li>stock (stock_num, <strong>manu_code</strong>, <strong>description</strong>, unit_price, etc.)</li>
  <li>orders (<strong>order_num</strong>, order_date, <strong>customer_num</strong>, ship_instruct, etc.)</li>
  <li>customer (<strong>customer_num</strong>, fname, lname, company, address1, etc.)</li>
  </ul>
  
  <p>This is my query right now, but I believe it is returning a cross product of some sort:</p>
  
  <pre><code>SELECT concat(c.fname," ", c.lname) AS fullname, s.description
  FROM items i, stock s, customer c JOIN orders o 
  ON o.customer_num=c.customer_num 
  WHERE o.order_num=i.order_num AND i.manu_code = 'ANZ';
  </code></pre>
  
  <p>Which returns a big list (1000 lines) with lots of duplicate entires,</p>
  
  <pre><code>Anthony Higgens | baseball gloves
  Anthony Higgens | baseball gloves
         .                 .
         .                 .
         .                 .
  Kim Satifer     | running shoes
  </code></pre>
  
  <p>What am I doing wrong?</p>