Thanks.
But how do I access tables in more than 1 databases in one session?
For example, in a java program I need to query tables in 2 databases.
In Oracle or db2 I can do
SELECT * FROM SCHEMA1.TABLEA join SCHEMA2.TABLEB
How to implement something like this in mySQL?
Thanks.