SQL Query - Table/Column Selection

For information on how to navigate to the SQL Query Entry Table/Column Selection window, see SQL Query Entry.

To create an SQL query

1. To insert table, view, or column information into your SQL query, select the required table. This will insert the fields in that table in the Column Selection pane. If you want to insert a single field from the table, select that field.
2. Position your cursor at the appropriate insertion point in the query entry pane. There are three ways to insert the table, view, or column into your query:
   
   1. Double-click the table, field, or view.
   2. Right-click the table, field, or view and select Add to Query.
   3. Select the table, field, or view and press Enter.
3. Single-click a table to display the table's columns in the Column Selection pane. Position your cursor at the desired entry point and double-click the column, or press Enter, to insert that column name into your SQL query.
    Notes:
   
   1. You can select multiple tables or columns to copy to your query (using Windows standards Shift-click or Ctrl-click).
   2. Typing a character in the table or column list will search for the first name that matches the entered character. Type the letter again, and it will find the next name that matches.
   3. You can expand either side of this window by using the one-touch resizable buttons ( ) that appear on the divider separating the Table/View and Column Selection views.
   4. Click on the Table/View, Column Selection, or Type headers to sort the entries.
   5. Ctrl-F invokes the Find/Replace window from which you can search for a specific table, view, or column.
   6. F3 finds the next occurrence of your search criteria.
4. Click Next to advance to the SQL Query Confirmation window.

Related Topics

SQL Query Entry 

SQL Query Confirmation

Retrieve an SQL Query

Modify an SQL Query in ConverterPro 

View/Edit Existing SQL Query Record Layout in ConverterPro

Delete an SQL Query Template

Work with SQL Queries