Show SQL Query Dialog Box
The Show SQL Query dialog box displays the SQL query that the program is sending to your SQL server. This dialog box appears when you right-click in the Report Designer, point to Database and click Show SQL Query.
| SELECT | SELECT lists all of the fields used in the report, including fields used in formulas, totals, the sort order, the selection formula, and ranges. |
| FROM | FROM lists all the tables used in the report, and each table name is followed by an alias name. |
| WHERE | WHERE specifies any links between tables and field ranges for the report. |
| ORDER BY | ORDER BY sorts the data in alphabetic or numeric ascending or descending order. |