PDA

View Full Version : Creating a List in Memory



mferrisi
06-11-2007, 01:15 PM
Using an ADO method to query, I want to run a query based on a list that I want to create in memory. So, I guess my query would look something like:

Select id, date, rets FROM [ This Table ] Where id is(Select distinct from theTableinMemory)

How would I go about creating this table in memory, if the list I wanted was held in an array?


I hope that makes sense.
Thank you,

Matt

geekgirlau
06-11-2007, 07:45 PM
I think you'll need something like

Select id, date, rets FROM [ This Table ] Where id in (1,2,3,4,5)