This list includes keywords currently supported by Network Reporting.
Provides a local alias for a SQL expression.
expression AS output_name
Ascending; usually used in an ORDER BY clause.
ORDER BY expression ASC
Descending; usually used in an ORDER BY clause.
ORDER BY expression DESC
Eliminates duplicate rows from a table.
SELECT DISTINCT column_name, ...
Enables a query to incorporate multiple related fields in Network as if they were a single field in the expression. For more information, see Field groups.
SELECT ... EXPLODE [field_set] AS [alias] ... FROM [table]
Transforms a single record with field sets into multiple output rows. One can use the result set as a subquery and perform further aggregation.
Derives a table from one or more other tables given in a comma-separated table reference list.
FROM table_reference [, table_reference [, ...]]
Evaluates a Boolean conditon. Can be used in conjunction with the JOIN types.
table1 JOIN table2 ON table1_column = table2_column