> >>> - Cross-Database-Queries
> >
> > Extend current SQL implementation to support database.tablename
> > notation as was used in QLI. Firebird can do it, its just not
> > surfaced in SQL. Sponsor?
>
> Sorry, but this look to me like PR ad. :-)
> Firebird as almost everyone knows is not capable of doing cross db

queries.

> What qli (the original client side tool) does is to retrieve records from
> one db, then from other when the user does nested GDML loops. The BDE did
> the joins itself when it was required to handle heterogeneous joins,

that's

> almost the same idea.
> But FB, the engine or the whole server is not capable of handling joins

from

> tables in different databases.

That being said -- it might be easier to introduce schemas/namespaces
than "true cross database" queries (when it comes to datafiles).

This way, you can have multiple "schemas" (in Firebird speak: databases)
inside a single datafile/filegroup (currently: database = 1 or more
datafile).

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com