Skip to end of metadata
-
Created by Former user, last modified by Former user on Oct 30, 2014
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 9
Next »
A SQL join clause combines records from two or more tables in a database.
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, 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>
...