OrderBy

Used to sort query results.

Visual SQL Query Builder dialog box, with the OrderBy tab displayed

Selected Table(s)

Displays the table being processed in generating a query.

Available Fields

Displays the fields of the table displayed in the Table dialog box.

If there are joined tables selected, the table's alias appears in front of each field's name, to distinguish fields from different tables.

OrderBy Field

Enter the field by which you want your query results sorted. Double-clicking a field in Available Fields copies it into the OrderBy Field text box.

Descending

When on, selects sorting in descending order. When off (the default setting), selects sorting in ascending order.

Clear

Deletes the contents of the OrderBy Field text box.

Apply

Copies the ORDER BY clause generated in the OrderBy tab page into the SQL Select Statement text box.