Subject Re: [firebird-support] missing WHERE
Author Nando Dessena

FL> SELECT field1 FROM table1 join table2 on (table1.field2=table2.field2) AND
FL> condition1 AND condition2;

FL> i forgot to change the first AND to a WHERE keyword and the query worked
FL> perfectly.
FL> FB1.0.3 on Linux

FL> is that normal?

Yes. The join condition became

(table1.field2=table2.field2) AND condition1 AND condition2

which is a perfectly valid one. I guess you noticed it by looking at
unexpected output...

Nando mailto:nandod@...