Differences

This shows you the differences between two versions of the page.

--- glossary:query_sql_form [2022/09/02 05:42] – ↷ Page moved from 7000_glossary:query_sql_form to glossary:query_sql_form administrator
+++ glossary:query_sql_form [2023/05/09 02:09] (current) – sean
@@ Line 1: / Line 1: @@
+{{tag>Index Glossary Query_SQL_Form Query}}
+===== Query SQL form =====
+The SQL form is a section of the query editor in the [[glossary:configuration_tool|Configuration Tool]] where the [[glossary:configurator|configurator]] can specify a [[glossary:query|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 [[glossary:query_simple_form|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:
+<code sql>SELECT
+   Member.*
+ FROM
+   Library_Member AS Member
+ WHERE
+   (Member.Age > 16) ORDER BY Member.LastName</code>
+This particular example can also be specified using the [[glossary:query_simple_form|simple form]].