select distinct teamMemberUserId, fspro_ownerType, fspro_ownerId, firstName, lastName, fspro_userId, fspro_ownerType + cast( fspro_ownerId as varchar ) as clientCode from qmd_territoryTeam order by clientCode desc, lastName, firstName -- ALL -- select broker_name from tblBrokers where broker_id = #htmleditformat( qmd_broker.broker_name )# #htmleditformat( lastName )# #htmleditformat( firstName )# -- #htmleditformat( request.portalConfiguration.apps.102.unassignedLabel )# --