Hi,

At June 26, 2003, 13:05, Helen Borrie wrote:

> From 1.5 on (maybe even 1.0, I can't recall) you can't do this any more:

> select a.f1, a.f2, b.fa, b.fb, c.fx, c.fy
> from a, b
> join c on...

In FB 1.0, it's still possible.

In FB 1.5, see examples below.

Works in FB 1.5:
select a.f1, a.f2, b.fa, b.fb, c.fx, c.fy
from a, b
join c on c.bid=b.id

Doesn't work in FB 1.5:
select a.f1, a.f2, b.fa, b.fb, c.fx, c.fy
from a, b
join c on c.aid=a.id

Notice where the tables are declared in the from clause in relation to
the join.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)