Hi All:

Consider the following table:

Artnum    Catnum
111         INT
111         ISR
111         GRP
222         INT
222         RSA
222         GRP

I want a select statement that says 'give me all the records for a particular artnum WHERE the artnum belongs to a catnum of BOTH 'INT' and 'ISR'.

This would produce the following list:

111         INT
111         ISR
111         GRP

Thanks,

Yossi