-
join or temp table
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|