select * from qmd_partnerContactRelationshipRanks where rankId = select * from qmd_partnerContactJobFunctions where jobFunctionId =

Contacts

Relationship Rank	Name	Email	Job Function	Title	Phone
#rankNameToUse#	#nameString#	#email#	#titleToUse#	#phone# Ext. #phoneExt#