On Tue, May 27, 2008 at 10:45 AM, Robert <birmingham_spider@...> wrote:

> The SQL isn't how I would have written from scratch either. The reason
> for its form is that the query was originally created in Access using
> the GUI tools. When the SQL got imported into the application a couple
> of years later I simply hit the Access SQL button to get the SQL.
> Rather than risk breaking something that worked, I COPIED and PASTED
> what was there, brackets and all.

You shouldn't really trust that much on this approach. MS Acess isn't
famous for following standards. So, what may work in Access may not
work in Firebird.

I didn't know DISTINCTROW existed in Firebird either. Is DISTINCTROW
part of the standard?

Fidel.