select distinct g.groupId, g.groupName, m.firstName, m.lastName, g.groupLeaderId from tbl_SEC_Groups g inner join tbl_FSpro_members m on m.fspro_userid = g.groupLeaderId and m.ownerId = g.ownerId and m.fsl_tablecode = g.fsl_tablecode inner join tbl_SEC_MemGrpLink mgl on mgl.groupId = g.groupId and mgl.fspro_userid = where g.OwnerID = and g.FSL_TableCode = order by g.groupName select distinct groupId from qmd_teams where groupLeaderId =

Manufacturer:	-- All Manufacturers -- #htmleditformat( mfrName )#
Report By:	TERRITORY TEAM
Territory:	-- All Territories -- #htmleditformat( territoryName )#
Work Team:	-- All Work Teams -- -- All Work Teams -- -- All Work Teams -- #htmleditformat( groupName )# - #htmleditformat( lastName )#, #htmleditformat( left( firstName, 1 ))#.