B.6. Select Structure

Each QueryExpression can be a Select describing the expressions (typically elements) being selected and a TableReference specifying the table or tables being selected from, along with any join information. The Select may optionally also supply a Condition (representing a SQL WHERE clause), a GroupBy (representing a SQL GROUP BY clause), a Condition (representing a SQL HAVING clause).