select ppl.principalId, m.mfr_name from tbl_BRO_Principals ppl inner join tblManufacturers m on m.mfr_id = ppl.mfrId where ppl.ownerId = and ppl.ownertype = and ppl.clientGapPlanEnrolled = 'Y' order by mfr_name
MFR Business Plan:
#htmleditformat( mfr_name )#