Manufacturer*: select distinct mfrId from tbl_SPL_Opportunities where ownerId = and ownerType = select distinct partnerId as mfrId, partnerName as mfrName from qmd_principals where partnerId in ( ) order by mfrName -- Select a Manufacturer -- #htmleditformat(mfrName)# -- All Manufacturers -- #htmleditformat( qmd_principal.mfrName )#