Previous Topic Next topic Print topic


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.
  1. Follow the steps in the topic To define an SQL call in Online Express, and define a Join call.
  2. Click Database Access > Explicit Join Specification. The Explicit SQL Join Specification dialog box appears.
  3. Select a 1st Join Table from its drop-down list and a 2nd Join Table from its drop-down list.
  4. 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.
  5. To specify a join condition, click On Clause. The On Clause dialog box appears.
  6. Set up the ON clause using the drop-down lists available on this dialog box; then click Apply.
Previous Topic Next topic Print topic