Creating SELECT statements

To create a SELECT statement:

1. On the Start page, click Select.

2. On the Tables page, select one or more tables from which you want to retrieve rows.

3. On the Columns page, specify which columns will be included in the result set.

4. On the Joins page, specify which columns will be joined between tables.

5. On the Conditions page, specify the search conditions that indicate which rows will be displayed in the result set.

6. On the Groups page, specify whether to include grouping columns in your SQL statement.

7. On the Order page, specify the order of rows in the result set.

8. On the Review page, verify the statement that was created.