You can enter the SQL statements in the text field.
You can open the Query Designer to graphically construct a query. See “Query Designer”.
In the Query Designer, select View | Generated Query or click the Generated Query tab, copy the entire or parts of the generated query, and paste it in the Query text field of the SQL Property window.
For Query properties, the Query Designer provides a
Save button. If you click it, the entire content of the Query text
field is replaced with the generated query.
You can select tables and attributes for your statements from the associated database schema by clicking the Database Lookup icon. In the Database Lookup window, select the tables and attributes you want to use in the statement and click OK.
