PO,

can you create a linked table in either one of the main databases?
then you can use 1 sql engine to do the work for you.

i dont see it happening the way you describe.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PO" <po wrote:

1. Is it possible to join two tables from two different databases (one
Oracle database and one MS Access database) in one singel select
statement??

2. Is it imposible to accomplish what I discribed below, that is,
joining two recordsets into one?

Regards,
Peter O

"Tom Ogilvy" wrote in message
...
You need to do the join in the sql statement that creates the records
set -
rather than creating two recordsets, create one recordset doing the
join
in
that sql statement.
--
Regards,
Tom Ogilvy