query on related tables

[php_coder]

Hello all,

I will be building the following database:

CATEGORIES
id
categorie

BRANDS
id
brand

PRODUCTS
id
prod_type

ITEMS
id
id_prod_type
id_categorie
id_brand

It will have four tables, 3 hold data and a fourth one holds the relations.

I what to query the database so that when I ask for 'MEMORY MODULES' it outputs the brands associated to the id of the produt 'MEMORY MODULES'.

:rolleyes:
Can someone please help me with the code?

Thank you.

[bastien]

something like

select 
  b.brand,b.id 
from 
  brands b,
  items i,
  products p
where
  p.id = i.id_prod_type 
and
  b.id = i.id_brand
where 
  p.product_type ='MEMORY MODULES'

[php_coder]

Thank you, I'll see how that works.