> I have several tables that I want to query as if their rows were in a
> single table. My thinking was to use a temporary table and execute
> multiple 'select into' queries to populate it and then run a final
> select against it.

E.g. insert a million rows from one table, insert one million rows
from another table, perform query that returns two qualified rows,
then delete everything ??

Ivan