select values common in > 1 row in a table

[SSG001]

I have a table which has different products and materials required to make those prodcuts something like this
prodcut material qty
prod1 mat1 10
prod1 mat2 20
prod1 mat3 10
prod2 mat1 20
prod2 mat3 30

I want to query those material which are common for both prodcuts
say like this
mat1
mat3

I nes to use this in php

Thanks in advance

[ronverdonk]

This should do it[code=sql]select material from table_name as t1 where material in (select material from table_name as t2 where t1.product != t2.product) group by material;[/code]Ronald

[SSG001]

This should do it[code=sql]select material from table_name as t1 where material in (select material from table_name as t2 where t1.product != t2.product) group by material;[/code]Ronald

Hey thanks a lot
it works

[ronverdonk]

Hey thanks a lot
it works

Knew it would. Glad to be of help. See you next time.

Ronald