>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

This is the problem that is called Relational Divison Problem. Peter Larsson has a very interesting blog about it.

http://sqlblog.com/blogs/peter_larsson/archive/2010/06/30/relational-algebra.aspx

one of the possible solutions:

select ArtNum from YourTable
where CartNum IN ('INT','ISR')
group by ArtNum
having MIN(CatNum) = 'INT' and MAX(CatNum) = 'ISR'