BOBJ - Outer Join

Card Puncher Data Processing

About

An outer join is a join that links two tables, one of which has rows that do not match those in the common column of the other table. More …

Definition

You define an outer join by specifying which table is the outer table in the original equi-join. The outer table contains the column for which you want to return all values, even if they are unmatched. You specify the outer table from the Edit Join dialog box for the selected join.

Left or Right Outer join

What is a SQL Left (Outer) Join?, SQL - Right Outer Join

Bobj Outer Join Properties

Designer displays the join in the Structure pane. The outer join is indicated by a small circle on the opposite side of the join to the table that returns unmatched values.

Bobj Outer Join Structure Pane

Full Outer Join

SQL - Full Outer Join

Bobj Full Outer Join Properties





Discover More
Card Puncher Data Processing
BOBJ - Joins (Home)

The Joins in BOBJ. You have several approaches to creating joins in : Tracing joins manually in the schema (Drag and drop) Defining join properties directly ( Menu Select Insert > Join ) ....



Share this page:
Follow us:
Task Runner