Hi,

I am working on a data warehouse and need to do some data pruning.
My question is, the tables that are affected can be joined, but these
two tables have a many-to-many relationship.

The easiest way I can think of would be to dump the results of a initial
query into a temp table and do another select to process the values in the temp table.

There is a better way, though, isn't there?

thanks in advance

billy