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

>At 12:09 20.06.2003 +0000, you wrote:
> >I'm using FB 1.5 RC3 but I have tested under 1.0.2 too and got the
> >same erro message.
>
>That eliminates the possibility of ambiguous field names having
>unpredictable results.

Set, I don't think it does, yet.

I want to know if there is any possibility that it is IB that is running,
not Firebird at all. The whole query should break Firebird's parser rules
about joins - on a Dialect 1 database it should give a warning and on
Dialect 3 it should fail.

heLen