You can use the Pre-join Editor dialog box to edit pre-joins in the selected data source of the current catalog. This topic describes the options in the dialog box.
Designer displays the Pre-join Editor dialog box when you select Pre-join on the Catalog Manager toolbar, then select a data source and select OK.
Designer displays these options:
Select to open the Add Tables/Views/Queries dialog box to add or remove data resources such as tables, views, synonyms, queries, imported SQLs, stored procedures, and user-defined data sources. Designer displays the added resources as tables in the editing panel.
Select to save all the changes in the dialog box.
Select to open the Edit Pre-join Paths dialog box to define pre-join paths.
Select to organize the tables that you add to the dialog box.
Designer displays the tables that you add for defining the joins in this panel. You can make joins between the tables by using mouse drag: point to one column in the source table, select and hold the mouse button, then move the pointer to the other column in the target table and release the mouse button. You can then see a green line with a join icon linking the two columns. If you want to further edit a join, double-click its join icon , Designer then displays the Join Options dialog box for you to edit it. After creating joins between the tables, you can use them to define paths.
Select to view information about the dialog box.