[V4RB] GROUP BY Recid Problems

[Francois Van Lerberghe]

le 7-02-03 9:07, Ruslan Zasukhin <sunshine at public.kherson.ua> a écrit :

> on 2/7/03 5:04 AM, Frank Schima at macsforever2002 at yahoo.com wrote:
> 
> Hi Frank,
> 
>> I'm trying to do a simple 3 table join with a sum() command and a GROUP BY.
>> But if I
>> GROUP BY the Recid field of a table, then ViSQL crashes on me. Ruslan, have
>> you seen this
>> problem before? Here is a sample:
>> SELECT a.Recid, a.Name, sum(c.amount) From a, b, c GROUP BY a.Recid
> 
> I do not remember,

Isn't it because we cannot set index on RecID ?

François Van Lerberghe
Thier Monty, 15A
B-4570 Marchin
Belgique