Select this option to add an ORDER BY clause to the current SQL select statement.  An ORDER BY clause sorts the rows in a result set by one or more columns in the select statement.

Pressing OK in the Order By dialog box adds the ORDER BY clause to the select statement.  The SQL Statement window displays the ORDER BY clause as part of the current SQL statement.

Order By Dialog Box

Table:

Select a table from the list of tables in the current select statement.

Column:

Select each column to be used for ordering.

Sort:

Add the column to the SORT list box.  This list box is the source for the columns used in the ORDER BY clause.

>

Use the > push button to move a column from the Columns list box into the Sort list box.  

<

Use the < push button to remove a selected column from the Sort list box.  

Ascending:

Check the Ascending radio button to sort by ascending order in the selected column.  Uncheck the Ascending radio button to sort by descending order in the selected column.