Multiple DB join

Hi All,

I have a database which consists of 20 million records and I've split up 
the db into 6-7 dbs. I have a base database which consists of
the ids with link all the databases. I'm performing search on this 
single base table. After searching i get some ids which are ids in the other
databases which i split up. Now i need to retrieve those records. Is 
there a way i can join tables from multiple databases as we can join 
multiple tables
in a single database.

Thanks,
SA.