https://my.oditech.com/downloads/FileMaker/13/fm13_sql_reference.pdf
Chapter 1 - Introduction
- About this reference
- Where to find PDF documentation
- About SQL
- Using a FileMaker database as a data source
- Using the ExecuteSQL function
Chapter 2 - Supported standards
- Support for Unicode characters
- SQL statements
- SELECT statement
- SQL clauses
- FROM clause
- WHERE clause
- GROUP BY clause
- HAVING clause
- UNION operator
- ORDER BY clause
- OFFSET and FETCH FIRST clauses
- FOR UPDATE clause
- DELETE statement
- INSERT statement
- UPDATE statement
- CREATE TABLE statement
- ALTER TABLE statement
- CREATE INDEX statement
- DROP INDEX statement
- SQL expressions
- Field names
- Constants
- Exponential/scientific notation
- Numeric operators
- Character operators
- Date operators
- Relational operators
- Logical operators
- Operator precedence
- SQL functions
- Aggregate functions
- Functions that return character strings
- Functions that return numbers
- Functions that return dates
- Conditional functions
- Reserved SQL keywords
