Attributes
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 |
Attributes
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 |