(Contents)(Previous)(Next)

Selecting Tables

To design a query, you must first specify the database tables you need for the formulation of the query. For this purpose, a selection window with tables is displayed. If you create a new query, this window appears automatically. If you modify an existing query, this window appears after selecting Tables.

Initially, you will only see your own tables, if any, in the Add Tables window. If you do not have your own tables, or if you want to add tables of other database users to your query, you can use the Owners of Tables combo box to specify the database user whose tables you want to see. You can also specify that you want to see all tables that are accessible to you. It depends on the Show Tables setting which tables are displayed (see Section Show Tables). It is possible to select and add several tables at the same time. To select a continuous block, use the key; to select several independent tables, use the key.

In the query design window, the selected tables are tiled on output. Afterwards, they can be moved freely. If all the tables cannot be displayed simultaneously, the scroll bars below and on the right of the displayed tables can be used.

If one of the available tables is to be deleted from your query, simply select the table to be deleted and press the key on your keyboard.


(Contents)(Previous)(Next)