Database Reference
In-Depth Information
Figure 6-8.
Starting the query editor
When the Query Designer launches, it will present the Add Table dialog window and a list of database tables.
Selecting one or more tables in this window adds the table names to the
FROM
clause of the new SQL
SELECT
statement you are creating. For example, if you select the Authors table and click the Add button, the Authors
table will be added to the query window (Figure
6-9
).
■
when the Query Designer is open, you cannot choose which database to use. if you do not see the
tables you were expecting, close the Query Designer, change the focus to the correct database, and then reopen the
Query Designer. You can use the database selector, indicated with a circle and an arrow in Figure
6-8
, to change the
database focus.
Important
If you want your query to include more than one table, you can hold down the Ctrl button, select multiple
tables, and then click the Add button. This feature allows you to create complex queries, such as SQL joins. After
you have selected all the tables you want to use, click the Close button to close the Add Tables dialog window.
