This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision |
| glossary:query_sql_form [2022/09/02 05:42] – removed - external edit (Unknown date) 127.0.0.1 | glossary:query_sql_form [2023/05/09 02:09] (current) – sean |
|---|
| | {{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]]. |
| | |
| | |
| |