Chapter 3 Building Physical Diagrams
You can view the clauses that are inserted in the query from the SQL page of the query property sheet. You can also edit the query manually from this page.