| The Query Builder can be used from within the SQL editor to create or modify the
select statement of your report. Simply drag tables and views from the Object Browser on
the left, and drop them into the work area on the right. If foreign key constraints exist
between the tables, you are automatically asked if they should be used for join
conditions. The columns can be selected for the field list, where clause and order by clause in the bottom section of the Query Builder. Various preferences affect the layout of the generated select statement, such as alignment, margin, case, and so on. |
