You are here:

Creating SQL Queries

For ODBC, Native Database, and certain Adapter connections, the Custom Query option allows you create a SQL query to, for example, select a subset of rows or columns in a table, or join multiple tables.

Source queries support

Unicode characters
All ASCII control characters, except:
- Vertical Tab
- Form Feed

To Create A SQL Query

In the Workbench, click Source > Configure. The Configure Source dialog box appears.
Select the Custom Query option.
Do one of the following:
- Enter a SQL statement in the SQL Query pane.
- Click Open Query, navigate to a saved query, and modify the opened query.
  Note:
  Use square brackets ([]) to enclose table and field names that contain spaces. For example:
  Select * from [company name]
If you want to include a system variable or a user variable, click User Variables.
If you have a saved query, click Open Query, select a query file, and click Open. If you select Yes when prompted to overwrite the existing query, the current query is replaced with the query in the file you open.
If you have created a query that you want to reuse, click Save Query, specify where to save the file, and click Save.
If you want to save a comment with the query, click Comment, type a meaningful comment, and click OK.
If you want to test the query for syntax errors and display the execution time. click Test/Requery. The correct SQL statement syntax depends on the database driver you are using.
Warning: Important! When you click Test/Requery, the query is executed. If the query includes update or delete statements,, your data is affected.

The result set from your SQL query displays in the Source pane of the main window.

Note: If your adapter does not support SQL syntax queries, you may be able to create a Insight Custom Query.

For information about creating SQL queries with Unicode data, see Unicode-compliant SQL queries