Join between two databases of different server

Question

I have two databases on different server : server A and server B

server A have table : user server B have table : userProfile

Is there any way by which I can join user to userProfile ?

[Joins between databases on different servers](http://stackoverflow.com/questions/5832787/mysql-joins-between-databases-on-different-servers-using-python/5832973#5832973). — Devart, Oct 08 '12 at 06:29
Please refer this: [http://stackoverflow.com/questions/5145637/querying-data-by-joining-two-tables-in-two-database-on-different-servers][1] [1]: http://stackoverflow.com/questions/5145637/querying-data-by-joining-two-tables-in-two-database-on-different-servers — Ryhan, Oct 08 '12 at 06:57

score 0 · Answer 1 · answered Oct 08 '12 at 06:27

0

Here you need to add server A as linked server to Server B or vice versa to access both the tables and join in any of the server A or server B.

answered Oct 08 '12 at 06:27

AnandPhadke

IN mysql is it possible to have linked server ? how ? – Amrish Prajapati Oct 08 '12 at 06:28
1

@Amrish Prajapati In MySQL - no. – Devart Oct 08 '12 at 06:34
refer this:http://stackoverflow.com/questions/5370970/how-to-create-linked-server-mysql – AnandPhadke Oct 08 '12 at 07:30

1 Answers1