Rick Debay wrote:

> In your opinion, does the subselect in the result set fall within the
> spirit and/or letter of SQL grouping rules?
>

Sigh. The intersection between the SQL standards and Firebird stored
procedures is confusing. The InterBase stored procedure design was
implemented before the SQL committee decided what the rules would be
and their rules and our implementation differ significantly.

I think your statement should work, but clearly the Firebird query
compiler does not agree. Perhaps the changes in V2 will improve its
attitude.

Cheers,


Ann