Union 2 table on 2 pc

[chinedra]

hi,
how can join 2 table of 2 db on 2 different pc ?

In sqlServer i just do:
selet * from pc1.dbo..db1.table1
union
selet * from pc2.dbo..db2.table2

in MySql ?????????

Thanks and sorry for my english !!!

 

[guelphdad]

Just remove one of the periods between the database name and the table name like this:

selet * from pc1.dbo.db1.table1
union
selet * from pc2.dbo.db2.table2

 

[chinedra]

I have try it, but not function.
Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.DB.Table' at line 1

 

[piti]

I don't think this will work - e.g. how do you authenticate yourself on the second server using query? ...