Hi Adam,

> select *
> from a
> left join (b on (a.id = b.aid) join c on (b.id = c.bid))
>
> which is of course invalid syntax. The closest you can get under
> Firebird 1.5 (apart from the view) is to use left joins, then to use a
> where clause to enforce the inner join.

Note that this is possible in every FB version:

SELECT
*
FROM
a
LEFT JOIN (b join c ON (c.id = b.bid)) ON (a.id = b.aid)

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database developer support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features:
http://www.firebirdsql.org
http://www.firebirdsql.info

Support list for Interbase and Firebird users:
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
news://newsgroups.firebirdsql.info