You can use SQL-derived tables to form part of a larger integrated query that uses assorted SQL clauses and operators.
