TeamForm Reports uses SQL which is a standard language for accessing and manipulating databases.
The SQL SELECT Statement
The SELECT statement is used to select data from a table.
The data returned is stored in a result table, called the result-set.
SELECT Syntax
SELECT column1, column2, ... FROM table_name
Here, column1, column2, ... are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following syntax:
SELECT * FROM table_name
The SQL WHERE Clause
The WHERE clause is used to filter records.
The WHERE clause is used to extract only those records that fulfil a specified condition.
WHERE Syntax
SELECT column1, column2, ... FROM table_name WHERE condition
Example
The following SQL statement selects the “firstname“ and “surname“ of all the people from the country "Mexico", in the "people" table:
SELECT firstname, surname FROM people WHERE country = 'Mexico'