[V4RB] GROUP returning too many records

Stan Busk maxprog at mac.com
Wed Jun 4 22:50:26 CDT 2003


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?

~/Stan



More information about the Valentina mailing list