select distinct mfr_bsr_id from tbl_CDR_Distributors where mfr_bsr_id in ( ) and ownerId = and fsl_tablecode = and crmActive = 'Y' select distinct lastName, firstName, teamMemberUserId from qmd_teamMembers where teamMemberUserId in ( ) order by lastName, firstName

Customer Manager:	-- select -- #htmleditformat( lastName )#, #htmleditformat( firstName )#
Manufacturer:	-- All Manufacturers -- #htmleditformat( mfrName )#