ainpoissee wrote:

>
> Makes sense... kind of.
> IMHO the JOIN ON clause should be used only to define relation between
> tables.

While you are certainly entitled to your opinion, the SQL standard
takes precedence in Firebird interpretation of a statement. The
standard describes the effective behavior of outer joins as building
an input stream based on the ON clauses then filtering the result
through the WHERE clause, as if the result of the joins were a
single table.

Regards,


Ann