select enabledChannels from tblManufacturers with (nolock) where mfr_id = select enabledChannels from tblBrokers with (nolock) where broker_id =