sql query question

[Guest]

I would like to run a query on the categories_to_products table to pull all product_id that has a particular category id. Then from that list of products ids I need to display the product id matches from the product_descriptions table. Just need assistance on correct procedure to run the query. What I tried gave me 7 million results but I only have 16k items so I know I did something wrong. thanks in advance for any help

[satish]

Try the following:(Change below p2c.categories_id and pd.language_id with your current value).

 

-------------------------------------------

 

SELECT pd.products_id FROM 'products_to_categories' p2c, 'products_description' pd WHERE p2c.categories_id='10' AND p2c.products_id=pd.products_id AND pd.language_id = '1'

 

 

-------------------------------------------

 

Satish