SELECT distinct b.Broker_ID, b.broker_name FROM tblBrokers b with (nolock) INNER JOIN tblBrokerOffices bo with (nolock) ON bo.Broker_ID = b.Broker_ID INNER JOIN tbl_SMA_BrokerOfficeLink k with (nolock) ON k.BrokerOfficeID = bo.Broker_Office_ID WHERE 1=1 and k.MFR_ID = AND k.TerritoryID in ( ) AND k.TerritoryID in ( )