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.
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster