To use

  1. Drag-and-drop Tables, Views, or Synonyms from the Schema Browser, Project Manager, Object Palette, or the Object Search window to the modeling area.

  2. Click in the check box by a column to select or clear it.

Note: Clicking this box adds the column to the main query. Columns must be added to subqueries by dragging.

  1. Drag-and-drop columns from one table to another to create joins between the tables.

  2. Add any WHERE clauses, or GROUP by clauses by right-clicking on the column in the tree view node and select Add to n clause. Right-click and adjust properties for clauses where necessary.

  3. Click the Save Model as button on the toolbar to save the model to disk.

  4. Click the Generated Query tab to view the generated query, and then click the Load in Editor button to copy the query to the Editor.

Press <F1> from the window for more detailed information about this window and how you can use it.