Daniel Rail wrote:

>
> I also agree that this feature will be useful. Because Firebird
> didn't use use DB aliases, like Sybase does, it probably would've been
> hard to implement.

Actually, GDML does use database aliases, and can use different
databases in nested statements, like this:

FOR X IN DB1.table1
BEGIN
FOR Y DB2.table1 WITH Y.field1 = X.field1
BEGIN
<do whatever to either table>
END
END

What it doesn't do is real joins. The problem isn't aliases, which is
easy, but query decomposition and optimization.


Regards,


Ann