Release 10.1A: OpenEdge Development:
AppBuilder

> ## Join mode

> When you activate the Join radio-set button in the Query Builder dialog box, you enter Join mode, and the Query Builder appears as in Figure 4–8.

> Figure 4–8: Query Builder in Join mode

> To enter this mode, you must already have selected at least two database tables. If you select more than two tables, you can use the down arrow button in the Join combo box to choose the combination of tables you want to join.

> If two tables are `OF` joinable, you can change their join criteria by activating the Customize Join toggle box to establish a `WHERE` clause between the two tables. Your comparison options are equal, not equal, less than, greater than, less than or equal, and greater than or equal. To use one of these options, double-click in a field from one of the tables, double-click on one of the comparison buttons, then click in another field from the other table.

> As you establish comparisons between fields, the AppBuilder displays the 4GL code in the Join Criteria panel. When you choose OK, the AppBuilder displays the code in the Query Builder’s Query field (and in the widget’s property sheet, if the query is an embedded one). You can link the comparisons with `AND` or `OR`.

> If you are familiar with the Progress 4GL, you can edit the Join Criteria field by clicking in it and typing in the code directly.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095