The left outer equijoin of tables A and B using ACITY = BCITY would be the union of the inner join of A and B and the unused rows of A extended with null values. Following is a query that would produce a left outer join:
FIND ALL tableA LEFT-JOIN(ED) BY keyA VIA keyB TO tableB
Following is the active found set:
|
A |
ACITY |
B |
BCITY |
|---|---|---|---|
|
A1 |
London |
B1 |
London |
|
A2 |
Paris |
? |
? |
|
A3 |
? |
? |
? |
|
A4 |
NY |
B4 |
NY |
|
A5 |
Madrid |
? |
? |
|
Copyright © 2014 CA.
All rights reserved.
|
|