[V4Rb] Error 346

[Charles Yeomans]

On Monday, December 8, 2003, at 05:23  PM, Ruslan Zasukhin wrote:

> on 12/9/03 12:18 AM, Charles Yeomans at yeomans at desuetude.com wrote:
>
>> The query
>>
>> SELECT Matters.RecID, Matters.matter_name,
>> SUM(TimeEntries.time_worked) FROM Matters, TimeEntries GROUP BY
>> Matters.matter_name
>>
>> results in error 346, "field name not unique", and it appears that the
>> inclusion of the Matters.RecID field is the cause.  I'm using the
>> current V4Rb beta.
>
> Hi Charles,
>
> Actually this must be other error code:
>
>     It is WRONG to use in SELECT fields that are not in GROUP BY.
>
> You see mistake?
>

I do -- except that the query

SELECT Matters.matter_name, Matters.last_changed, 
SUM(TimeEntries.time_worked) FROM Matters, TimeEntries GROUP BY 
Matters.matter_name

does execute, and returns correct results.

?

Charles Yeomans