Creating and Running SQL Queries

You can create SQL queries either by entering SQL statements directly into an SQL window (click
SQL Window button
on the SQL Wizard toolbar), or by using a prompted query in the Query Design window (click
Query Design button
on the toolbar). You do not need to understand SQL to create a prompted query. The Query Design window is split into two areas:

When you create a prompted query, you first select the table and columns. Then you apply conditions and sort criteria to the columns to achieve the final result set. Further choices are available from the menus, including joins, the creation of computed columns and the use of built-in functions such as minimum, maximum and average.

As you create a prompted query, the equivalent SQL statements are built up by SQL Wizard. To see them, click
SQL button
. You can edit the SQL statements directly but the changes you make do not appear in the Query Design window. To go back to the Query Design window, click
Query Design Window button
. It's a good idea to save your prompted query before you try editing it in the SQL window. You can run your query and see the results at any time by clicking
Run button
.