Or this

SELECT * FROM mytable t1
  WHERE EXISTS (SELECT 1 FROM mytable WHERE Artnum = t1.Artnum AND Catnum = 'INT')
    AND EXISTS (SELECT 1 FROM mytable WHERE Artnum = t1.Artnum AND Catnum = '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