Hello, i’ve database A in and database B in several server respectively. Is there any manner can be a part of them collectively to pick out question?
Thanks for serving to.
Whereas there are lots of choices how to connect with each databases, you’ll not get the choice of native queries over tables from each databases. It is because SQL is distributed to the database and the result’s computed by the database server and returned to your program.
The one manner for a single SQL question to make use of tables of each databases is that if the databases are related not directly supported by the DBMS (search for linked database/linked tables in your database guide).
The one manner fora program to mix information from two distinct databases is to ship two separate SQL queries to the databases and mix the outcomes.