To define an explicit Join specification
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- Follow the steps in the topic
To define an SQL call in Online Express, and define a Join call.
- Click
Database Access >
Explicit Join Specification. The Explicit SQL Join Specification dialog box appears.
- Select a
1st Join Table from its drop-down list and a
2nd Join Table from its drop-down list.
- From the
Join Type drop-down list, click the type of Join you want to create:
- 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.
- To specify a join condition, click
On Clause. The On Clause dialog box appears.
- Set up the ON clause using the drop-down lists available on this dialog box; then click
Apply.
