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
)
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