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 |
|
Copyright © 2014 CA.
All rights reserved.
|
|