What is a clause in a SQL report?

In SQL a clause is a tool which allows specific parameters to be set on what results should be brought back in a SQL report.

Examples of some of the clauses that can be used in SQL:

CLAUSE	WHAT DOES IT DO?
WHERE	A clause which filters results to exclude or include specific content defined by a rule.
JOIN	Two or more tables to be reported on in the same report.
GROUP BY	Collect all information with the same piece of data into a specific cell.
HAVING	Allows more limitations to be placed on the GROUP BY clause
ORDER BY	Show the results in a specific pattern.