Hi

I have this table

COD CAT PROD
---------- ---------- ----------
300004 5 6
300004 5 7
300007 5 7
300007 5 6
300007 5 12
300008 5 6
300008 5 7
300008 5 8

I need to write a qeury which returns me cod 30008 only, that is prod is 6 and 8 and cat is 5, I have tried some queries but all returns more results than I need. Anyone know how can I accomplish this?