Previous Topic Next topic Print topic


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.
Previous Topic Next topic Print topic