Specifications

Using SQL Select
170 InfoMaker
❖ To edit the SELECT statement:
1 Select Design>Convert to Syntax from the menu bar.
InfoMaker displays the
SELECT statement in a text window.
2 Edit the
SELECT statement.
3 Do one of the following:
• Select Design>Convert to Graphics from the menu bar to return to the
SQL Select painter.
• Click the Return button to return to the wizard if you are building a
new report, or to the Report painter if you are modifying an existing
report.
Joining tables
If the report will contain data from more than one table, you should join the
tables on their common columns. If you have selected more than one table,
InfoMaker joins columns according to whether they have a key relationship:
• Columns with a primary/foreign key relationship are joined automatically.
• Columns with no key relationship are joined, if possible, based on
common column names and types.
InfoMaker links joined tables in the SQL Select painter Table Layout view.
InfoMaker joins can differ depending on the order in which you select the
tables, and sometimes the InfoMaker best-guess join is incorrect, so you may
need to delete a join and manually define a join.
❖ To delete a join:
1 Click the join operator connecting the tables.
The Join dialog box displays.
2 Click Delete.
❖ To join tables:
1 Click the Join button in the PainterBar.
2 Click the columns on which you want to join the tables.
3 To create a join other than an equality join, click the join operator in the
Table Layout view.