2 messages in com.mysql.lists.javadata from 2 databases in MySQL
FromSent OnAttachments
Sandesh Kurle06 Nov 2001 12:44 
Mark Matthews06 Nov 2001 12:53 
Subject:data from 2 databases in MySQL
From:Sandesh Kurle (sku@guarded.net)
Date:11/06/2001 12:44:23 PM
List:com.mysql.lists.java

Hi,

Is there a way to do a JOIN on 2 tables in different databases in MySQL. I know we have to use a 'use DB1' before connecting to mysql, so how can we make such a JOIN between tables T1 and T2 residing in DB1 and DB2. If there is any workaround using Java or something else and a way to create 2 resultsets and then combine them do let me know, if anyone has done such a task before.

Thanks ! Sandesh