select f.fspro_userid, f.firstname, f.lastname, f.firstname + ' ' + f.lastname FullName, t.name as primaryTerritory from tbl_FSPro_Members f left outer join tbl_TER_Territories t on f.primaryTerritoryid = t.territoryid where f.fsl_TableCode = and f.ownerid = and f.staffMember = 1 and f.recState = 'A' Order by firstname, lastname select distinct ter.territoryid, ter.name as territoryname, tm.teamMemberRole from tbl_ter_teammembers tm inner join tbl_ter_territories ter on ter.territoryid = tm.territoryid where tm.teammemberuserid = and tm.ownerid = and tm.ownertype = and tm.teammemberrole = 'TeamMember' order by ter.name select distinct ter.territoryid, ter.name as territoryname, tm.teamMemberRole from tbl_ter_teammembers tm inner join tbl_ter_territories ter on ter.territoryid = tm.territoryid where tm.teammemberuserid = and tm.ownerid = and tm.ownertype = and tm.teammemberrole = 'TeamManager' order by ter.name

UserID	First Name	Last Name	Full Name	Primary Territory	Team Member Territory(s)	Team Manager Territory(s)
#qry_getStaff.fspro_userid#	#qry_getStaff.firstname#	#qry_getStaff.lastname#	#qry_getStaff.fullName#	#qry_getStaff.primaryTerritory#	#_teamMember#	#_teamManager#