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 ???
>Thanks...

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.

HTH


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


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


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