Hi all,

What is the way to make a join from 2 tables in two respective database (in same server) ?

ex : 

Db1

TableA

Db2

TableB

how can i make somethink like this :

SELECT tA.MATRICRS, tB.name, tB.age

FROM TableA tA

JOIN TABLEB tB ON ( tA.ID = tB.ID)

ps:  I use FlameRobin to write sql statement.