Hey,
why command "group by" and "where" do not work together?
Example:
CREATE TABLE TEST1

>(
>  COD char(1),
>  SUMA smallint
>);

INSERT INTO TEST1 (COD, SUMA) VALUES ('A', '3');

>INSERT INTO TEST1 (COD, SUMA) VALUES ('B', '3');
>INSERT INTO TEST1 (COD, SUMA) VALUES ('B', '7');
>INSERT INTO TEST1 (COD, SUMA) VALUES ('A', '4');
>INSERT INTO TEST1 (COD, SUMA) VALUES ('C', '5');
>INSERT INTO TEST1 (COD, SUMA) VALUES ('D', '6');

this work
SELECT COD, sum(SUMA) as suma

>FROM (select cod,suma from TEST1 where cod<'C')
>group by cod ;

this do not work
SELECT COD, sum(SUMA) as suma

>FROM TEST1
>group by cod 
>where cod<'C';

Thanks in advance.

[Non-text portions of this message have been removed]