A select query that locates records in one table without any related records in another table.
A select query that performs an action on the query’s results in some way, such as by changing a field.