Specifications

CHAPTER 5 Defining Reports
Users Guide 171
The Join dialog box displays:
4 Select the join operator you want and click OK.
If your DBMS supports outer joins, and the Allow Cross Product option is
set in the Query Governor, outer join options also display in the Join dialog
box.
About the Query Governor
You can use the Query Governor to set data selection and retrieval options.
For more information about the Query Governor, see “Using the Query
Governor” on page 48.
Using ANSI outer joins
All InfoMaker database interfaces provide support for ANSI SQL-92 outer join
SQL syntax generation. InfoMaker supports both left and right outer joins in
graphics mode in the SQL Select painter, and full outer and inner joins in
syntax mode. Depending on your database interface, you might need to set the
OJSyntax DBParm to enable ANSI outer joins. For more information, see
OJSyntax in the online Help.
The syntax for ANSI outer joins is generated according to the following BNF
(Backus Naur form):
OUTER-join ::=
table-reference {LEFT | RIGHT} OUTER JOIN table-reference ON
search-condition
table-reference ::=
table_view_name [correlation_name] | OUTER-join