Adding tables

You use the Tables window to add a table to a query when you are building the query using the Prompted Query editor. You can also use this dialog to change the tables that have been specified in the query.

About this task

To add a table to a query when you are building the query using the Prompted Query:

Procedure

  1. Open the Tables window from the Prompted Query editor.
  2. Identify the table that you want to include in the query. Type the table owner in the Table owner field.
  3. Click the Add Table toolbar button in the Tables pane.
  4. Type the table name in the Table name field.
  5. If you do not know the table owner and name, you can search the data source to see what tables are available. To search for a table:
    1. Specify the owner identifier of the tables that you want to include in the list in the Table Owner field. You must specify the owner in the correct format for identifiers. You can specify a matching pattern to match multiple names. To list all tables use the % sign.
    2. You can further narrow the tables listed by using the name field. Specify an identifier for the table names that you want to include in the list in the Table Name field. You must specify the name in the correct format for identifiers. You can specify a matching pattern to match multiple names. To list all tables for a particular owner use the % sign.
    3. Click the Add From List button to search the data source for tables that match the criteria that you specified. The Table List window opens listing all the tables on the data source that met your search criteria.
    4. Select a table to include in the query from the list of tables.
  6. If you want to use the specified owner name for each successive added query, select the Save Owner Filter check box. Each time that you open the Tables dialog, box the saved owner name will automatically be displayed in the Table owner field.
  7. Click Add. The table is added to the query. The name of the table appears in the Tables pane of the Prompted Query editor.
    If you add at least one more table to the query, the Join Tables dialog opens. In the dialog, you must specify the table joining option. For more information about table joining options, see the Joining tables topic.
    Note: The Join Tables dialog appears only if the tables in your query are not joined in the data source ER Diagrams.