[V4RB] GROUP returning too many records

Stan Busk maxprog at mac.com
Thu Jun 5 01:00:52 CDT 2003


I meant

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

Sorry,
~/Stan

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



More information about the Valentina mailing list