Creating a simple query 1

[rvr1]

Hi,

This is my first real project using mysql and PHP and would like some help creating a query please.

I have two tables:

Table 1 [product_id, product_desc, product_cost]

Table 2 [brand_id, category_id, product_id]

What I want to do is search table 2 for entries where the brand_id and category_id meet certain criteria.

Then I wish to extract the list of product_id's and use these to pull out the product_desc and product_cost from table 1 where the product_id matches the results of the search.

I hope that makes sense. Appologies if this appears overly simple to some people - as I said, it's my first attempt!

Thanks )

 

[ericbrunson]

select product_desc, product_cost
from   table1, table2
where  table1.product_id = table2.product_id
and    brand_id = <criterion>
and    category_id = <criterion>;