temp DB tables

[khue]

How do I create 2 temporary database tables that will be populated and later retrieve the data with SQL to form a third table. For example


<!--- Create and define table 1 with SQL --->
...


<!--- Create and define table 2 with SQL --->
...


<!--- Populate table 1 with SQL --->
...


<!--- Populate table 2 with SQL --->
...


<!--- Fetch data from table 1 and 2 with SQL.
Desired result is in this query --->
...


<!--- Looping through this query --->
...

 

[iqof188]

I'm not sure what you want to do, but you can always use the CREATE TABLE statement in SQL (also in a CFQUERY). But I'm not sure that's a good idea. Maybe you can use structures (they look a lot like db tables...) to hold the data, or maybe even WDDX packets. Anyway, please be more specific on your problem, or try CREATE TABLE.


<webguru>iqof188</webguru>