Greg Dodd doesn’t need no steenkin’ tables:
Sometimes you have a list of values or parameters that you’d like to run a select statement over the top of to get a result. There’s a few ways of doing this, usually I see people create a Temporary Table and insert the data. But is there an easier way?
Yes, we can select from VALUES:
The result of this is called a virtual table, and as far as other parts of the query are concerned, it’s just another table.