Join

Name	Description	Value
outertable	A table name	Any table name that exists in database
innertable	A table name	Any table name that exists in database
jointype	The type of join	INNER, LEFT_OUTER, RIGHT_OUTER
conditions	The conditions that follow the join

Name	Description	Value
outerfield	The field of the outertable table which will join with the innertable table	An existing field name from innertable table
innerfield	The field of the innertable table which will join with the outertable table	An existing field name from outertable table
condition	The compare operator	=. >, <, >=, <=, <>
andor		AND, OR