DQL Statements › Relationship Clauses › Types of Outer Joins and Disjunctions › Disjunction of Tables

Disjunction of Tables

The words disjoin or disjunction describe the result of an outer join with the rows of the inner join removed. The following query produces a left disjoin:

   FIND ALL tableA LEFT-DISJOINED BY keyA VIA keyB TO tableB

For example, the left disjoin of tables A and B using ACITY = BCITY produces this active found set:

The preceding sample represents an active found set resulting from the left outer join of A and B with rows of the inner join removed. A right disjoin of tables A and B could be similarly defined.

The following query produces a full outer disjoin:

   FIND ALL tableA OUTER-DISJOIN(ED) BY keyA VIA keyB TO tableB

The full outer disjoin of tables A and B using ACITY = BCITY results in the following active found set: