Use the in operator with a subquery to compare a value to a dynamically generated list of values. This list is really the result of another query (the subquery).
