--- In firebird-support@yahoogroups.com, Jonathan Neve wrote:

> Do you mean that the joins aren't being used for anything? The
> reason is that I omitted the where clause, in which these are used.
> Obviously, I need them, otherwise I wouldn't bother posting this
> question.
>
> My point was that the joins weren't behaving correctly. Whether or
> not I use the joins, they should still function correctly...

Then, why don't you show us the entire select, Jonathan? I'm not
conserned if Firebird gives strange results to meaningless queries,
but if the results should happen to be weird in useful cases, then
that would be a problem that ought to be addressed.

For myself, I cannot see any point in left joins when you don't select
anything from the right tables. Though that may be due to limited
experience.

Set