Previous Topic: Left Outer JoinNext Topic: Disjunction of Tables


Right Outer Join

The following query produces a right outer join of tables A and B:

   FIND ALL  tableA  RIGHT-JOINED BY keyA VIA keyB TO tableB

The right outer join of tables A and B with ACITY = BCITY produces the active found set below:

A#

ACITY

B#

BCITY

A1

London

B1

London

?

?

B2

Oslo

?

?

B3

?

A4

NY

B4

NY

?

?

B5

LA