select ter.ownerId, ter.fsl_tablecode, ter.territoryId, ter.name territoryName, ter.primaryManager, m.fspro_userid, m.firstname, m.lastName, m.email, m.title, ter.internalSalesID from tbl_TER_Territories ter inner join tbl_FSpro_members m on m.fspro_userid = ter.primaryManager and m.ownerId = ter.ownerId and m.fsl_tablecode = ter.fsl_tablecode inner join tbl_TER_TerritoryLevels l on l.levelId = ter.levelId and l.ownerId = ter.ownerId and l.fsl_tablecode = ter.fsl_tablecode where l.ownerId = 26 and l.fsl_tablecode = 'MFR' and l.rank = 4 and l.ownerId = and l.fsl_tablecode = and ter.internalSalesId in ( ) and ter.territoryId = order by territoryName

Monthly Business Review Tester

Region	RSM	Report
#htmleditformat( territoryName )#	#htmleditformat( firstName )# #htmleditformat( lastName )#	#htmleditformat( internalSalesId )#

#_reportHTML#