Aivar,

k> I had problems with a query that gave false results, then I noticed
k> that i hadn't qualified one of the fields in coalesce in select.
k> Unfourtunately firebird didn't warn about it and just used one of the
k> tables (listed at the end of from clause) where a field with this
k> name could be found.

which database dialect and connection dialect are you using?
Dialect 1 is much weaker than 3 at detecting ambiguities.

Ciao
--
Nando Dessena
mailto:nandod@...
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================