Database 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.
