[V4RB] GROUP returning too many records

[Stan Busk]

Hi,

Noway, I've tried:

  SELECT Sum(Amount)
    FROM Accs, Type1, Type2
    WHERE Type1='3' OR Type2='3'
    GROUP BY Type1, Type2

and now it returns 29 records. Tell me if you want to see the code.

Stan

On Wednesday, June 4, 2003, at 11:12  PM, Ruslan Zasukhin wrote:

> on 6/4/03 23:50, Stan Busk at maxprog at mac.com wrote:
>
>> Hi,
>>
>> I have this code:
>>
>>    SELECT Sum(Amount)
>>    FROM Accs
>>    WHERE Type1='3' OR Type2='3'
>>    GROUP BY Type1, Type2
>>
>> It works everywhere in my application returning 1 or 2 records but in
>> one place I get 42 records. The database is made of about 100 records.
>> How can this happens?
>
> Try add Type1 and/or Type2 fields into SELECT
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>