Thanks to everyone that posted. I used

select clientid from

clients

where regionid = 28

and clientid in

(

 select clientid from clients where regionid = 1

)

and it works

August 18, 2004 at 6:42 pm