moving data from one data source to another

[adumas77]

I'm trying to move data from one data source to another. I don't want to loop -
because it will kill performance. A simple Select into or Insert into using a
select statement is what I need. I seem to be hung up on the from clause of
query q4... Is this the proper way to access another query? What am I doing
wrong? <cfquery name='q2' datasource='OracleDb'> select * from Pets
</cfquery> <cfquery name='q3' datasource='AccessDb'> drop table Pets
</cfquery> <cfquery name='q4' datasource='AccessDb'> select petname, store
into Pets from 'q2' </cfquery>

[shahzad]

is your q4 just a pseudo-code or is that the actual sql that you are writing? can you do that??

where are you selecting petname from? you didn't specify any table

[adumas77]

No, this is not pseudocode... petname, store are 2 columns in the q2 query.

So far, nobody knows if I can do a 'select into' where I reference data from datasource and insert it into another.