Skip to end of banner
Go to start of banner

Join

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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

 


  • No labels