On Mon, 11 May 1998, David Hartwig wrote:
> It is not very difficult to produce this problem in MS Access 97; I
> expect my users to beat me up pretty good on this issue. Thus, I plan to
> look into making the fix in the backend myself. Conceptually it does not
> seem too difficult.
>
> 1. Add a hidden attribute to the target node structure.
>
> 2. Modify the parser/analyzer to add any attributes in the GROUP/ORDER BY
> clause that are missing from the target list, to the target list with the
> hidden attribute set.
This would be a great enhancement!
SQL92 specifies that columns in the ORDER BY must appear in the
SELECT clause, but this limitation has no sense, indeed many databases
already implement this enhancement.
Go for it!