| Panel | ||
|---|---|---|
| ||
An SQL join clause combines records from two or more tables in a database.
What does this section cover?
|
Attributes
| Name | Description | Value | ||||
|---|---|---|---|---|---|---|
| indexorder | The order number of the join. | Any number | ||||
| outertable | A The outer table name. | Any table name that exists in database | ||||
| innertable | A The inner 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 |
...
| . | Conditions | Name
Example
...
| Expand |
|---|
...
|
...
=. >, <, >=, <=, <>...
| |||||||||
|