In this section, we will learn how to make a more specific query by choosing the columns and limiting the rows that R:BASE retrieves from the database using a more defined WHERE Clause. Let's use Query Builder to build this query.
Building a query with the Query Builder:
| 1. | From the Group Bar, select the "Views" option and select "New View". |
A pop up will appear asking if you would like to use the Query Wizard.
| 2. | Select No. |
The "Query Builder" window is displayed.
On the left, the "List of Tables/Views" drop down menu provides option to displays tables, views, system tables, or all for the connected database. The right and bottom panels display portions of the query that make up what is being asked from the database. These panel contents will change as you build and modify the query. The "Tables/Views in Use" panel will display any tables/views that are added to the query. The bottom panel is the SELECT command syntax that is automatically generated during the query creation.
| 3. | From the "List of Tables/Views" section, limit the list to "Tables", then select Flights and click the "Add Table/View" button to add the table to the query. |
"Flights T1" appears in the "Tables/Views in Use" panel. The "T1" is an alias name for the table Flights. Each time a table is selected in the Query Builder, R:BASE gives the table an alias name. The alias number on your screen may not be the same as in this lesson. Also notice that the SELECT syntax has changed to include "FROM Flights.T1."
