So far in the database examples in this book, you have worked with fairly straightforward SELECT statements. This section provides you with the concepts involved in defining more complex database queries. You will learn how to use many of the features of VA Smalltalk's SQL Editor to use high-level qualifiers, sort and restrict the results of a query, nest SELECT statements, and use dynamic WHERE clauses.