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
>
Can you create a 'fact' table containing the infomration that you are
querying? This goes
against normalization but if the table will only be used for querying
purposes then this
will eliminate your need to perform joins.
-Original Message-
From: Tim McDonough
To: [EMAIL PROTECTED]
Sent: