Explicit Join Specification
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- Join Table
- Select a table to serve as the first table in the Join.
- Join Type
- Select the type of join you want to create, as follows:
- Inner
- Combines each row of the 1st Join Table with every row of the 2nd Join Table keeping only the rows where the join condition is true.
- Left Outer
- Includes the rows from the 1st Join Table that were missing from the inner join.
- Right Outer
- Includes the rows from the 2nd Join Table that were missing from the inner join.
- Full Outer
- Includes rows from both tables that were missing from the inner join.
- 2nd Join Table
- Select a table to serve as the second table in the Join.
- Undo Explicit Join
- Click this to undo the join specified on this dialog box.
- On Clause
- Click this to define an ON clause for the Join.
