>In article <5.1.0.14.0.20021022122446.02924130@[158.36.132.22]>, Svein Erling
>Tysvaer wrote:
> > >Is Interbase supporting cross-db query?. If not, how I can join two
> tables
> > >resides in two different databases?
> >
> > No, you simply cannot do this.

Well you could, back in the bad old days...

database db1 = filename "abc.gdb";
database db2 = filename "def.gdb";

for x in db1.table1
for y in db2.table1 with x.f1 = y.f1
(do whatever)
end_for
end_for

Nested for loops aren't quite the same as a join,
but they did work...

And how did this valuable capability disappear from the
product? Well, it's like this. With nested for loops,
there's no question about the join order. Optimizing
join order in a distributed query is a hard (and very
interesting) problem. We just discussed it to death every
time it came up.

Regards,

Ann
www.ibphoenix.com
We have answers.