Filtering based off a prefiltered list in SQL

28 September 2019
28 Sep 2019
1 min read

Having been able to write more SQL in the past week, I came across a great piece of code that I want to save for future use.

I wanted to find all transactions that was part of a specific list in order to do market basket analysis from those specific entries.

One easy way to do that is to grab all of the transaction IDs into a temp table, and then use that temp table in a Where clause, selecting from the original data set.

So it would look something like this:

Select TransIDs into #transactions From table where _conditions_

select transaction_members from table where transIDs in #transactions

Pretty quick way to find your all items where one needs to be from a filtered list.

Want to know more?

I spend a ton of time thinking on how to work smarter, not harder. If you'd like to be the first to know what I'm thinking about, sign up to the list below.

Updating your tools

Parable of the Pots