Filtering a query based on results of another query

K

Karen

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
 
T

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
 
Top