(how) Can I JOIN SELECTs from multiple databases into a DBgrid?

Question

I have separate MySQL database servers.

How can I JOIN the data from queries to the databases on these servers, and show it on a DBgrid?

@Jan - Your edit probably hides the fact that there are no connection between servers. If that is the case that is.. Also in which case the question definitely is not a duplicate. — Sertac Akyuz, Sep 11 '13 at 10:52
You either make the servers available so that you can write a single query to access them (in SQLServer it's as a linked server), or you create a temp table on the local machine, select from each server into those temp tables, merge the tables (even if it's one row at a time via a table), and then query the local data. — Ken White, Sep 11 '13 at 11:02
@Sertac I went back to the original question but don't read that. What he writes is that one central server is out of the question because the four locations want to have their servers in-house. — Jan Doggen, Sep 11 '13 at 11:09
How many fields are we stitching together and how large is the dataset? It might be practical to load all the datasets to the client and provide calculated fields on the 'master', or as Max suggests - populate a ClientDataset — Hugh Jones, Sep 11 '13 at 13:00

score -1 · Answer 1 · answered Sep 11 '13 at 11:45

-1

I have different queries and combine it manually in a TClientDataSet.

answered Sep 11 '13 at 11:45

markus_ja

1

This is not an answer, unless you edit it to add much more detail. As is, it's a comment to the question. – Ken White Sep 11 '13 at 13:16
-1. This answer should be deleted in the actual formulation. – RBA Sep 11 '13 at 18:11
@max, +1 not highly infomative, but it's a starting point for me. Thanks – Mawg says reinstate Monica Sep 13 '13 at 07:25

1 Answers1