Re: [firebird-support] Firebird : join table from two database

2017-01-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 12-1-2017 21:44, startx252...@yahoo.fr [firebird-support] wrote: > 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

Re: [firebird-support] Firebird : join table from two database

2017-01-12 Thread Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
Hi, look at my example that I'm using for preparing two DB fou join into one big. My be it will help you. -- Prepare data table for replication -- Ensure that data in both databases are unique -- No overlap during replication will occur CREATE OR ALTER PROCEDURE Repl$SynchronizeDataTable(

Re: [firebird-support] Firebird : join table from two database

2017-01-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.01.2017 21:44, startx252...@yahoo.fr [firebird-support] wrote: > What is the way to make a join from 2 tables in two respective database (in > same server) ? No. -- WBR, SD.