On Step 2 of the Database Integration Wizard, you may click in the SQL statement box and type the full SQL statement.
For help with SQL commands and reserved words, table names and column names:
Click to place your cursor in the position where items should be pasted into the statement.
Right-click in the SQL statement box and select an option from the right-click menu. See below for more information.
Each option presents a list of items that can be pasted to the location of your cursor in the SQL statement box.
Select one or more items from the list, and then click OK.
Reserved Words
Reserved Words perform specific tasks in SQL.
Clicking this option displays a list of SQL Reserved Words.
To paste one or more Reserved Words into your SQL statement, select one or more items on this list and then click OK.
Tip: The first three items in the list – SELECT, FROM and WHERE – are the most commonly used for creating an SQL statement to return a specific query result set.
Table Names
The connection you set up on Step 1 of the Database Integration Wizard referenced a database or other set of tables. To quickly access the names of these tables, click Table Names on the right-click menu.
This displays a list of table names available to the selected connection.
To paste one or more Table names into your SQL statement, select one or more items in the Table list and then click OK.
Column Names
For any table available to the selected connection, you can quickly access the names of all columns in that table. Click Column Names on the right-click menu.
This displays a screen that allows you to choose column names for any of the tables available to the selected connection.
Click the Table list and select the name of the table for which to find column names.
Tip: If the SQL statement already contains only one table name, it will automatically be selected in the Table list.
Select one or more items from the Column or Field list, and then click OK. The column names you selected are pasted into the SQL statement.
To access column names from another table, repeat these steps.
More: