2012

The following additional interface elements are introduced on the SQL Query
tab:
■ Table List. Lists all database tables available in the current data source. You
can add tables to the SQL query editor by double-clicking them, by selecting
them and choosing Add, or by typing their names directly in the SQL query
editor.
■ Check. Checks your SQL query for proper syntax without actually executing
it. This function helps you isolate syntax errors before you issue your query.
To construct an SQL query
1 Open the Query Editor as described in To open the Query Editor.
2 Click the SQL Query tab.
3 Enter your query in the Query Editor, or select query components from
the interface as described in
Use the Query Builder on page 2037.
4 If you want to save the query in the current drawing for future use, click
Store.
5 Click Execute to execute the query and close the dialog box.
Quick Reference
Commands
DBCONNECT
Provides an interface to external database tables.
Combine Queries
An advanced type of query uses operators on successive selection sets to return
a new set of objects or records, which then can be further refined by the same
process.
Link Select is an advanced implementation of the Query Editor that constructs
iterative selection sets of graphical objects and database records.
Link Select creates an ongoing selection set that you refine with additional
information through a running iterative process. You begin either by
constructing a query or by selecting graphical objects. This initial selection
set is referred to as set A. You can now select additional graphical objects or
Combine Queries | 2041