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