select 'BRO' as ownerType, 'BRO:' + convert( char, broker_id ) as id, broker_name as text from tblBrokers with (nolock) where oneFSEnabled = 'Y' union select 'MFR' as ownerType, 'MFR:' + convert( char, mfr_id ) as id, mfr_name as text from tblManufacturers with (nolock) where oneFSEnabled = 'Y' order by ownerType, text