Here is a list of common query syntax that can be used:

• Adding a field:
• Select <field_name> From <table_name>
• Adding a table:
• Select * From <table_name>
• Specify a field alias:
• Select <field_name> AS <alias_name> From <table_name>
• Join tables:
• Inner Join: Select table1_name.column_name From table1_name Inner Join table2_name On table1_name.column_name = table2_name.column_name
• Left Outer Join: Select table1_name.column_name From table1_name Left Join Table2_name On table1_name.column_name = table2_name.column_name
• Right Outer Join: Select table1_name.column_name From table1_name Right Join table2_name ON table1_name.column_name = table2_name.column_name
• Sort data:
• Select * From <table_name> Order By <field_name> ASC/DSC
• Filter data:
• Select * From <table_name> where [CONDITION]
• Apply Aggregate Functions:
• Select aggregate_function(table_name.field_name) From <table_name> Where [CONDITION].
• Grouping:
• Select * From <table_name> Where [CONDITION] Group By <table_name.field_name>.

Users may encounter an error when attempting to save or validate a data set that contains any of the keywords listed below (including in SQL comments). This is a protective measure used to identify and block potentially unauthorized database commands.

• insert
• update
• delete
• drop
• execute
• exec
• sp_
• xp_

You can add to your query to sort data in either ascending or descending order based on one or more fields in the table.

1. Edit the data set and add Order By <field_name> ASC/DSC.
2. For example, the image below has added Order by initiatedate ASC to the query to sort the report in ascending order by the initiated date.