The second tool, the Query Generator, allows you to create the SQL in a single screen. If you have some basic SQL knowledge, you will find the Query Generator much faster than the Query Wizard.
The system displays the full SQL command and allows you to edit the SQL directly if necessary.
You can also enter an entire SQL statement directly into the Query Generator.
Like the Query Wizard, the Query Generator will automatically supply the inner join when you select more than one table for a query. Although it does not show you the list of tables related to your chosen table, fields that are keys to related tables are shown in bold. You can drag and drop the bolded field to the table selection column and the Query Generator will open the related table, allowing you to select fields from that table.