run a 2nd query based on results of first 1

[scottaherbst]

Out clients can get a lot of different services at the same time. The only place to go to find out which ones they are getting is in a table "service_records" which lists all the services ever delivered. I want to know which clients are getting one particular type of service - x. Easy enough. I just query to find all of the instances of x service.

Here's my problem. I then want to go back to the data that report generates, take the client id number, and find out all of the services (x, y, and z) those clients are getting. Any idea how to use the results of one query to serve as the basis for the next?

Thanks,
Scott

 

[synapsevampire]

You could use a Command Object and paste in SQL, as in:

select id,fld from table1
where id in
(select id from table1 where fld ='X')

Dpeends on your Crystal version and the database being used, please post the basics in the future.

-k

 

[scottaherbst]

Sorry - crystal reports 10. SQL database is on a server. Thanks, I'll give that a try.
Scott