Re: MySQL query from multiple tables

it sounds like you may be serializing your SQL, in which case the following link might help. http://www.ashleyit.com/rs/jsrs/select/php/select.php Matthew Nock wrote: > Hi All, > > I have a strange query which I need to build - I have looked at the JOIN and > aliasing functions of mySQL but not sure if I can achieve want I want to do. > > I have two tables (product_head, and product_features) (in addition to a > number of other tables) which form the list of products I have available, > and the features available with each product. > > I want to be able to retrieve from product_head the rows which are for a > specific product category (ie: 1).. this bit is easy. > > SELECT * from product_head where prod_cat_ID = 1; > > This query could return 1 or more rows - works great. > > but I also want to retrieve records from the product_features table. > information stored in this table is: > > prod_ID feat_ID feat_value > > so for each product ID, there could be any number of features. I need to > retrieve only certain feat_value records, for specific products, where the > feat_ID equals certain values . > > can I build a single query that will return all these results similar to > below? > > Prod_ID Prod_name Feat_1_value Feat_2_value feat_3_value > 1 prod1 34 25 15 > 2 prod2 10 15 15 > ... > > does this all make sense?