select top #_maxItems# broker_id, broker_name from tblBrokers bro with (nolock) where ( ( bro.broker_name like ) and 1 = 1 ) and exists ( select * from tblBrokerOffices with (nolock) where broker_id = bro.broker_id ) order by bro.broker_name #_data#