How to write MySQL query on 2 different tables residing in 2 different databases on 2 different servers?

I have 2 tables

table1 in database1 on server1 having userID and userName

table2 in database2 on server2 having 开发者_如何学编程 userID

I need a way to access table1 on server1 to get the userName of the userID in table2

How do I do query using MySQL?

I think you can use 2 different connections:

$connection1= mysql_connect('server1', 'user1', 'password1');
$connection2= mysql_connect('server2', 'user2', 'password2');

Retrieve data from database 1, and use it to query database2. Or the opposite, depending on what you need. This means you'll use 2 queries.

Edit: I automatically assumed you're using php, hence my answer. I'm sorry if it's irrelevant.

MySQL supports federated tables - tables housed in a physically distinct server instance. It makes the remote table appear local, and any queries executed on it are transparently sent to the remote server for execution.

not sure about mysql...

in Oracle you would link the databases and then fully qualify the table references in your query (with '.' seperators)