How to query multiple Databases in different servers?

Can anyone say how do I connect/merge in a query multiple databases in different servers? The “database wizard” gives me only the option to connect to a single database (I am using ODBC).

A query syntax example would be very helpful if possible.

Does ODBC support connecting to multiple servers simultaneously? Could you add something about your goals? I guess this is just not possible in the database support that is pretty extensive for an office suite, though limited compared to custom applications that have been programmed to query different databases. There may be different solutions to your problem.

I would like to query something like:
“SELECT * FROM server1.dbx.table-a and server2.dby.table-b”

I’ve been looking for this as well - unfortunately does not seem possible with current Base - MS access has had this for the 16 years at least also i am sure I have seen similar with crystal reports. personally i stick with access for adhoc queries and data manipulation and loading it up to main db server. As it support several back ends u would think Base was functioning as an abstraction layer so would be feasible but i guess it is a ‘won’t fix’ type of feature request Yes i’d like to see it!

LibreOffice does not support connecting to multiple databases via ODBC at the same time. So in short: you can’t.

In general, applications (in this case your Base file) do not query tables spread across multiple databases on different servers in one query. Data from different databases is first gathered and normalised and put in one database schema by the data abstraction layer or an application built especially for doing this.