You can examine the SQL statements generated by the Query Design window by switching to the SQL Edit window.
To switch to the SQL Edit window:
While in the SQL Edit view, you can make changes to your query that would be difficult to make through the prompted Query Design window. You can also edit other types of commands that are not currently supported by the Query Design window.
If you make changes to the SQL statement while in the SQL Edit window, you will not be able to go back to the Query Design window without discarding those changes. You can, however, first save the prompted query in Query Design mode, switch to SQL Edit mode, and save the modified SQL statement as an SQL script file.