 <p>Look into <a href="http://dev.mysql.com/doc/refman/5.0/en/join.html" rel="nofollow">joins</a> for selecting data from multiple tables:</p> <pre><code>SELECT * FROM Prices LEFT JOIN (Vendors, Products) ON (Products.product_id=Prices.product_id AND Vendors.vendor_id=Prices.vendor_id) </code></pre>