Filtering a query based on results of another query

[Guest]

Hi,

I would like to filter a query based on the results of another query. The
results of the first query may have more than one record.

Thanks

 

[Tom Ellison]

Dear Karen:

Two (out of many) ways of doing this come to mind, depending on more
specifically what you want to do.

If the subsidiary query shows which rows you want to display, using it as a
subquery of an IN() clause would be useful.

In other cases, an JOIN of the two would be useful.

To be of more help, considerable detail may be necessary.

Tom Ellison