Tim McDonough writes:
>The solution I presently have does a query for the first criteria.
>Then, I loop through the results of that query and do another query
>for each returned row. This produces the desired results but requires
>a lot of queries, i.e.-- if the first query returns 1000 customer
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
> two criteria whether
* Tim McDonough
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
>
CTED]
Sent: 4/9/04 8:20 AM
Subject: Better Solution than Multiple Queries?
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to di
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two criteria whether or not the
