select l.division from tbl_TER_TerritoryLevels l inner join tbl_TER_Territories t on t.levelId = l.levelId where t.territoryId = and t.fsl_tablecode = and t.ownerId =

Sales Territory	select * from baseQuery where territoryId in ( ) select min( rank ) as minRank from qmd_ownedTerritoryHierarchy #RepeatString("&##160;&##160;", rank - minRank )##territoryName# select min( rank ) as minRank from request.qmd_userTerritoryHierarchy #RepeatString("&##160;&##160;", rank - minRank )##territoryName#
Sales Person
Customer Name*
Street:
Street 2:
#label#*:
#label#:
Main Phone:	[nnn-nnn-nnnn]&##160;&##160;&##160;Ext.&##160;
Preferred Distributor:
Secondary Distributor:
Web Site URL:
Primary Segment:	-- Unknown -- #RepeatString( "&##160;&##160;", clientSegLevel-1 )##description#
Classification*:	-- Select Classification -- #qmd_classifications.name#
Cuisine:	-- Unknown -- #qmd_cuisines.cuisineName#
Primary Contact	(check to add contact)
Contact Name*:	#qcf_listSalutation.Salutation# &##160; &##160;
Job Function*:	-- Select One -- #jobFunctionName#
Contact Title:
Email Address:
Phone:	&##160;Ext.&##160;
Cell: