[V4RB] GROUP returning too many records

[Ruslan Zasukhin]

on 6/5/03 12:00, Stan Busk at maxprog at mac.com wrote:

Hi Stan,

I have open your database,
Open it in visQL,
And do query as 

SELECT Transaction_AccountDebited, Transaction_AccountCredited,
       SUM(Transaction_Amount)
FROM Transactions 
WHERE (Transaction_AccountDebited='3' OR Transaction_AccountCredited='3')
GROUP BY Transaction_AccountDebited, Transaction_AccountCredited


I see results as

    
    3       1       746,47
    3       2       4096
    3       4       ...
    ...
    3       41      ...
    10      3
    16      3
    ...
    39      3


Stan, everything is CORRECT.

42 records. Why you wonder ???

As you see pairs {Transaction_AccountDebited, Transaction_AccountCredited }
Give us UNIQUE value pairs.
All right.

If you expect other result, then you need probably other SQL query.


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