Self restricting joins

Card Puncher Data Processing

About

A self restricting join is not really a join at all, but a self restriction on a single table. You can use a self restricting join to restrict the results returned by a table values using a fixed value.

Example

Bobj Self Restricting Join Example

Properties

For example, if you want to restrict the returned values from the Family_code column to 'F3', you replace Article_lookup.Family_code (which come from table2) after the = sign with 'F3' as shown below:

Bobj Self Restricting Join Properties

In a structure pane

The self restricting join appears as a short line displayed against the column on which the self restricting join is defined.

Bobj Self Restricting Join Structure Pane





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