select cho_id from tbl_CHO_Operators as subgroups with (nolock) where cho_id in ( select distinct ownerId from tbl_OPR_CLientOperators with (nolock) where fsl_choId > 0 and fsltablecode = 'CHO' and recordSource like '%via CHO' + convert( varchar, fsl_choId ) ) Go here.