TRY THIS:

SELECT ClientID FROM ClientRegs WHERE RegionID=1 AND ClientID in

 (SELECT ClientID FROM ClientRegs WHERE RegionID='2')

IT WORK FINE FORM ME.