There are 5 jointypes to choose from.
| Type of join | Description |
|---|---|
| 1=Inner | Include only records where the joined fields from both tables are identical. |
| 2=Outer | Include all records from the first table and only those records from the second table where the joined fields are identical. |
| 3=Inner top 1 | Displays the first record where the joined fields from both tables are identical. With regard to the first record, it can be influenced by sorting in descending or ascending order. |
| 4=Outer top 1 | Include all records from the first table and only the first record from the second table where the joined fields are identical. With regard to the first record, it can be influenced by sorting in descending or ascending order. |
| 5=Not Exists | Include only records from the second table where the joined fields are not identical. |