Thank you, Sergey. Both worked and both are clever.

>Try

>SELECT t1.* FROM mytable t1
>  WHERE 2 = (SELECT COUNT(*) FROM mytable t2 WHERE t2.Artnum = t1.Artnum AND t2.Catnum IN ( 'INT', 'ISR'))
>
>

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