Filter In Database based on list of data from another database query

[erickastupart]

I am querying several databases to create one Excel file.  One of the databases has millions of records and I'm trying to figure out how to filter on a specific list of approximately 40,0000 business unit numbers from another database query. Due to the number of records, it would take hours to run without the filter.

I have the business unit numbers in a select tool from the other query and it seems like I could place a filter where the purple circle is in the attached pic, however I don't know how to accomplish this.  

[ChrisWaspe]

Hi @erickastupart . I may be misunderstanding the data and the problem, but would a join on the business unit number not return the desired output?

[alexnajm]

Hi @erickastupart,

I would use a Summarize In-DB tool to make sure your business units list is unique so the Join doesn't result in duplications. Otherwise I agree with @ChrisWaspe that a Join In-DB tool could do the trick!

Let me know if you want to jump on a call as I am pretty sure we currently work together 😊

[erickastupart]

Alex, I will email you some days/times I'm available.

Thanks,

Ericka