Kbase 15753: Report Builder - Table1 OUTER JOIN Table2 INNER JOIN Table3
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Report Builder - Table1 OUTER JOIN Table2 INNER JOIN Table3
----------- ----------- -----------
| Table1 | --------- | Table2 | --------- | Table3 |
----------- ----------- -----------
/\ /\
OUTER JOIN INNER JOIN
In V8 Report Builder (2.0) if you create the joins above
and there is a record in Table1 that joins to a record in Table2
but there is no related record in Table3, none of the records
from the 3 tables will be displayed.
The overall effect is as if there were an inner join between Table1
and Table2. What is happening is that the outer join is done on
Table1 and Table2 and that is stored as one intermediate record
(Table1 + Table2 = Table12). Then the inner join is done on
Table12 and Table3. Since there is no record in Table3, neither of the
records are displayed.
This is the ANSI SQL Standard.
If you want Table1 and Table2 to display even if there is no Table3,
then you must make the join between Table2 and Table3 an OUTER JOIN.
Progress Software Technical Support Note # 15753