Selecting Columns Using SQL Select

In the Table Layout view, click each column to include from the table representations.

The columns you select are highlighted and placed in the Selection List at the top of the SQL Select painter.

  1. In the Table Layout view, click a column once to select it.
    Option Description
    Select all columns from a table Right-click on the table name and select Select All.
    Reorder the selected columns Click and drag a column in the Selection List. Release the mouse button when the column is in the proper position in the list.
  2. To see a preview of the query results, click Execute in the Painter bar.
    A table displaying the query results appears in the Results tab.
  3. Click OK.
Parent topic: Using SQL Select