create 1 query from two databases

[make me rain]

with VB6 (ado) + Access03;
-------------------------
how can i generate a query using two tables from two different data bases ( one is .mde and another .mdb)

(1) i opened the connection and recordsets of the both the
data bases
(2) confusion from here on wards
i want to inner join the .mde1 table with .mdb2 table
and extract some sorted records
any advice please.