Building queries

Getting started

Building a single query

Adding an object to the query

Setting object aliases

Joining tables

Selecting output fields

Sorting a dataset

Defining criteria

Grouping output fields

Defining SQL query properties

Building a query with sub-queries

Navigating the query tree

Working wih sub queries

Working with derived tables

Working with unions