Thanks Jessica.
KPatrick, aside from the lookup function, if you only need to filter based on one column in your 3rd dataset, you can have that dataset return the appropriate column only, then set a Multi-Valued Parameter based on that dataset.
Then use that parameter in the WHERE clause of your dataset (e.g. WHERE IN(@myparam)). Since the Multi-Valued Parameter comes out formatted as a comma-separated list, it effectively filters your final dataset based on the values in the first dataset.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."