--- In firebird-support@yahoogroups.com, "sibyltalk" <sibyltalk@...>
wrote:

>
> It would seem to make sense to put common, essentially static,
> reference tables into a separate database that could be accessible to
> various projects, each project corresponding to a separate database.
> Helen Borrie's text mentiones transactionality across multiple
> databases, but I have been unable to find how you would refer to such
> a lookup table from another database either as a foreign key or in a
> WHERE clause. Can anyone tell me how to do it, or point me to a
> reference resource? Thanks.
>

You can't reference two databases from a single query in Firebird. You
may start a transaction that spans two databases which has a 2 phase
commit. Your client program would need to do the join logic if applicable.

Adam