I have a query that I wish to write that will need to utilize a table in a local database server and a table in a remote database server. How can I accomplish this?
I.E.
Table 1: users
IP 1: l27.0.0.1
Table 2: patients
IP 2: 10.0.10.11
I would need to do somthing like this (though I know this syntax is really wrong)
select a1.*
from 127.0.0.1.db1.users a1 inner join 10.0.10.11.db2.patients a2 on a1.id = a2.id
Is this possible?
I.E.
Table 1: users
IP 1: l27.0.0.1
Table 2: patients
IP 2: 10.0.10.11
I would need to do somthing like this (though I know this syntax is really wrong)
select a1.*
from 127.0.0.1.db1.users a1 inner join 10.0.10.11.db2.patients a2 on a1.id = a2.id
Is this possible?