Skip to end of metadata
-
Created by Former user, last modified by Former user on Oct 10, 2016
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 11
Next »
A SQL join clause combines records from two or more tables in a database.
Attributes
| Name | Description | Value |
|---|
| indexorder | The order number of the join. | Any number |
| 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, RIGHT |
| conditions | The conditions that follow the join. | Conditions |
Example
Join
<join>
<indexorder>3</indexorder>
<outertable>PRODUCTS</outertable>
<innertable>PRODUCTFAMILIES</innertable>
<jointype>LEFT</jointype>
<conditions>
<conditionitem>
<outerfield>PRODFAMILYID</outerfield>
<condition>=</condition>
<innerfield>PRODFAMILYID</innerfield>
<andor>AND</andor>
</conditionitem>
</conditions>
</join>