Adding columns to the SELECT query

After adding one or more tables to your query, you should select which columns (or fields) from those tables should be returned in the query result set and/or to used as criteria for which records will be included in the query result set.

You can use one of the following methods to accomplish this:

• In the table display on the top half of the screen, select the check box for each field you want to add to the query.  Or, to add all of the fields at once, select the check box for * (All Columns).
  
  

• In the grid on the lower half of the screen, click on a cell in the Column column.
  Then click the drop-down arrow to display a list of all of the fields in all of the tables in your query.  Select the desired field from the drop-down list.  Or, to add all of the fields from one table at once, select tablename.* .
  
  

• In the grid on the lower half of the screen, click on a cell in the Table column.
  Then click the drop-down arrow to display a list of all of the tables in your query.  Select the desired table from the drop-down list.
  
  
  
  Next, click on a cell in the Column column and select the desired field from the drop-down list.  Or, to add all of the fields from this table at once, select * from the list.
  
  

When a new Column (or field) is added to the last empty row in the grid, a new empty row is provided.  This allows you to continue adding new fields to the grid.

To remove a Column (or field) from the grid, you may clear the check box for that field in the table display on the top half of the screen.  You can also click the gray selector at the left side of the row to select the entire row, or click and drag across multiple row selectors, and then press the DELETE key.

More:

Setting the sort order

Adding criteria for the column

Adding GROUP BY and aggregate functions

Hiding a column from the query results

Setting an alias for the column

Working with columns in a SELECT query