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')>
>Artnum Catnum >111 INT >111 ISR >111 GRP >222 INT >222 RSA >222 GRP >>
>111 INT
>111 ISR
>111 GRP
>
>