At 04:46 PM 20/06/2003 +0200, you wrote:

>Well, Luciano, it is good to hear that you are satisfied, but the plan
>reported by IBExpert does indicate that something still is wrong. But, that
>is your problem and if neither you nor your customers discover it, then you
>may get by without fixing it. And I do not know Firebird well enough to say
>that your select gives you wrong results, just that the plan indicates that
>it is trying to do something you never intended it to do.

I agree. I would definitely want to redo a version of the query with fully
qualified column names on everything and compare plans and outputs.

(Or, rather, *knowing* that qualified identifiers would make it
unquestionably unambiguous, honestly, I'd just do it. :-))

h.