[V4RB] GROUP returning too many records

[Ruslan Zasukhin]

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
-------------------------------------------------------------