Databases Reference
In-Depth Information
Figure 2-18.
The initial Query Builder screen
From here you can begin to build your query. To include a table in your
select
statement, simply click it in the
list to the left. A representation of the table is placed in the blank region of the screen above the Conditions region.
You may add as many tables as you like to your query and may even include the same table more than once by
clicking it again. Notice that if you include more than one instance of the same table, the new instance is suffixed with
a sequence number differentiating it from the original table.
Figure
2-19
shows an example graphical representation for the
DEMO_ORDERS
table and outlines the different
interactive features.
