User`s guide

Note:
For more information on query filter operators and values, see Query filters and prompts.
5.
Click Add a subquery to add an additional subquery to the query filter.
By default the two subqueries are linked in an AND relationship. Click the AND operator to toggle
between AND and OR.
In addition to linking subqueries in AND or OR relationships, you can nest them (create subqueries
within subqueries) by dragging an existing subquery to the white area of the subquery outline. In
this case the inner subquery becomes part of the WHERE condition of the outer subquery.
16.6.2.2 Subquery parameters
A subquery or set of subqueries contains the following parameters:
DescriptionParameter
The object whose values are used to filter the re-
sult objects.
You can include more than one Filter Object. If
you do, Crystal Reports concatenates the values
of the objects you specify.
Filter Object(s)
The object that determines which Filter Object
values the subquery returns.
You can include more than one Filter By object.
If you do, Crystal Reports concatenates the values
of the objects you specify.
Filter By Object(s)
2012-03-14356
Building Queries