Subject Re: [firebird-support] Connect 2 databases
Author Alexandre Benson Smith
At 18:39 21/01/2004 -0200, you wrote:

>Hello all,
>Is possible to use tables of diferents databases in one view.
>for example in MSSQL I use :
>Create view a_plus_b as
>select a.user_name, a.cd_user,
> b.adress, b.number
>from test.dbo.a, test2.dbo.b
>where a.cd_user = b.cd_user
>Someone can help me ???

No, in current firebird version you could not do cross database selects...
May be in a future release, this has been discussed before...

You can connect to 2 (or more) databases in your client application. and
merge the data.


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.564 / Virus Database: 356 - Release Date: 19/01/2004

[Non-text portions of this message have been removed]