Subject Re: [firebird-support] Cannot use distinct together with subselect
Author Daniel Rail

At September 10, 2003, 14:24, Florian Hector wrote:
> Daniel,

> This is true and I have changed it. Thanks.
> But what I meant was the subquery for the 3rd field.
> As so often, the sparking idea comes to mind right after one hits the send button.
> Instead of the subselect I now use a second join. With this, distinct cause the error.

The bug was fixed in FB 1.5:
* Fixed unregistered bug.
"Context already in use" error in the case of DISTINCT with

Also, make sure that the subquery only returns one row, otherwise
you'll get an error.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (