Thank you for your response.
The reason that I need a table is that I am using the data as a subquery.
Can I use a recordset as a subquery? I couldn't seem to figure out how to do that.
Okay, here's what I am trying to do. I have an some data that I need to be able to use as the IN clause of a different SELECT. The data gathered for the IN clause has to be generated procedurally, and cannot be done in a single select. I can put that data in a recordset, an array or a temp table. If I put it in a temp table, I can't delete the temp table. If I put it in an array or a recordset, I don't know how to use that as a subquery for the IN clause.
The recordset method would be a wonderful solution, but I can't figure out how to use it in a subquery.
Any ideas?
Thank you!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement