Query SQL form
The SQL form is a section of the query editor in the Configuration Tool where the configurator can specify a query using the SQL, a language that database management systems understand. It can be used by SQL experts for queries that are too complex to be defined in the simple form and, for some reasons, cannot be specified using the rule form. For example, a query in the SQL form that finds all members over 16 years old and lists them in the alphabetical order may look like this:
SELECT Member.* FROM Library_Member AS Member WHERE (Member.Age > 16) ORDER BY Member.LastName
This particular example can also be specified using the simple form.