Connect to SQL database and Oracle database at the same time

Hi,

I have inherited a cold fusion site.  Throughout the site, it has
individual examples of where it connects to our SQL database and
individual examples of where it connects to our Oracle database.  I
now find that I need to connect to do a join on some tables in both.
For example, these statements work fine when accessing only one
database at a time:

<CFQUERY name="sqlquery" datasource="SQLdatabase">
	Select SqlField FROM mySQLtable st
	WHERE id = 1
</CFQUERY>

<cfquery name="oraclequery" datasource="Oracledatabase">
		SELECT OracleField from myOracletable ot
			WHERE id = 1
</cfquery>

I need to find some way to run a statement that accesses both as
follows:

Select SqlField, OracleField From mySQLtable st
JOIN myOracletable ot ON st.id = ot.id
WHERE id = 1

Is this possible?

Thanks,
Amy