title: Retrieve data from multiple tables
body: <p>I have 3 tables, want to write the select result but I don't know how to use 'join' 'inner' 'outer', etc, would be grateful if someone help me.</p>
  
  <p>Tables: manufacturers / products / products_description</p>
  
  <pre><code>$manufacturer_query = "SELECT manufacturers_id from manufacturers WHERE manufacturers_name='" . $m ."'";
  $manufacturer = mysql_query($manufacturer_query);
  $mresult = mysql_fetch_array($manufacturer);
  
  $products_query = "SELECT p.products_id, pd.products_description FROM products p, products_description pd WHERE p.products_id=pd.products_id AND p.manufacturers_id=" . $mresult['manufacturers_id'];
  $products = mysql_query($products_query);
  $presult = mysql_fetch_array($products);
  
  
  $c = 0;                            
  while ($presult){
  $c++;
  echo $c . ' - ' . $prod['p.products_id'] . ' - '.$prod['pd.products_description'].' - ' . $mresult['manufacturers_id'] . '&lt;br&gt;';
  }
  </code></pre>