2004

Use Queries to Filter Database Information | 761
Unlike the other tabs in the Query Editor, the SQL Query tab can be used to
construct a query that performs relational operations on multiple database
tables using the SQL join operator. Because joins are a relatively advanced
SQL operation, refer to your database system documentation or to the SQL
92 protocol for information about working with joins.
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” on page
754.
2 Choose 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 758.