Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Attributes

NameDescriptionValue
outertableA table nameAny table name that exists in database
innertableA table nameAny table name that exists in database
jointypeThe type of join
INNER, LEFT_OUTER, RIGHT_OUTER
conditionsThe conditions that follow the join 

 

...

Attributes

NameDescriptionValue
outerfieldThe field of the outertable table which will join with the innertable tableAn existing field name from innertable table
innerfieldThe field of the innertable table which will join with the outertable tableAn existing field name from outertable table
conditionThe compare operator
=. >, <, >=, <=, <>
andor AND, OR

...