Querying the Database

When you have connected to a database, as shown in the previous section, the Database Explorer is updated to show the actual database in the connections list, and the tables in a scroll list. The following picture shows the result of connecting to the publisher database. This contains a number of tables. If you select one of the tables, its columns will be shown and you can select any of these (a button is provided to select all the columns).

If you click the Result tab, this will select the data from the table and selected columns. Here is an example.

The Query page also has an Advanced Options button. When you click this button more options for forming the query are provided. For example, you can put various conditions on columns. Here is an example where data in the LORANGE column must be greater than 5000.

Clicking the Result tab will run the query and display the results.