MySQL dbForge - Querying between different connections (same schema)

Question

I've just started using MySQL dbForge and I would like to know how to query between different connections (same schema used for all of them).

Here is my situation:

Here I want to do a join between these two tables, but I'm not sure how to tell to dbForge that I'm working with different connections.

Happy New Year! Wish you all the best in 2019!

Looking forward to your replies. ;)

the dbs are on the same server of are on different servers ?? — ScaisEdge, Jan 01 '19 at 19:19

score 0 · Answer 1 · answered Jan 03 '19 at 11:54

0

In mysql once a connection is estblished all the dbs and the table accessible by the user are (based on user grants ) directly usable as ..

 select a.col1, b.col1
 from db1.table1 a 
 inner join  db2.table2.col2 b  on a.keycol = b.colkey

answered Jan 03 '19 at 11:54

ScaisEdge

Thanks for the answer. However, that was not my question. My question was as title says "Querying between different connections...", not "Querying between different databases..." – BlueDev Jan 07 '19 at 20:16

1 Answers1