Since this is off-topic, feel free to respond directly to
rdebay@.... Thanks.

We have two fairly complex SQL commands, each to a different database.
These queries have been added to a Crystal report using the "Add
Command" listed in the "Database Expert" (separate data-sources, since
Firebird doesn't support multiple database queries).

We intend to join the data on the client side using the SQL designer,
and need to know how Crystal Reports will implement the client side
join. Does Crystal retrieve the results from the first command, and then
issue a separate query against the second command for each row in the
result set? Or does it retrieve both result sets in their entirety, and
then join them together on the client? Is there a way to control how CR
will execute this kind of request?

Rick DeBay