join multi server

hi,

consider this:

i have american users in a db called "user" in a server called AMERICA

and rest of the world users in a db called "user" in a server called OTHER

how can i do a join betwhen American's users and Rest of the word's User db?

SELECT *

FROM AMERICA.user.dbo.MyTable t1

JOIN OTHER.user.dbo.MyTable t2 ON t1.id=t2.id

|||Make sure you have set uplinked server to the remote SQL|||ok many thanks, it will be very usefull for my