
Join QueryDef with two datasources
I need to create a join query taking table data from two seperate
datasources (SQL Server & Oracle). I have an ODBC driver to handle
both the connections so thats not the problem. However, I don't know
how to work with two separate recordsets at one time.
I'm just looking for the proper syntax or at least a yes or no that it
can be done. Just point me in the right direction.
Thanks in advance,
Greg