For interactive assistance in building a query, select the option that allows you to use tables and columns that you specify. Two separate screens in the wizard assist you. The first screen guides you through selecting the table to publish and identifying the columns that will be seen in the HTML page. The second screen assists you in selecting the rows that will make up the table to be displayed.
The Select Table and Column and Select Rows dialog boxes offer these options.
| Use this option | To do this |
|---|---|
| Available tables | View tables that may be published from the database chosen. |
| Table columns | View available columns (based on your security) contained in that table. You can move columns to the Selected columns list of the Select Table and Columns dialog box. |
| Selected columns | View columns that you have selected to be published on the HTML page. To remove a column, double-click it then click Remove. |
| All of the rows | Include every row from the selected table in the HTML page. |
| Only those rows that meet the following criteria | Specify row selection criteria. Optionally, you can specify an AND or OR operator. |
| Only those rows that qualify using the SQL WHERE clause | Specify constraint conditions using the WHERE clause. You can also append an ORDER BY clause to order the data for your HTML page. |