Hello, CREATE TABLE [pcprod] ( [codigo] NVARCHAR(20) NOT NULL ON CONFLICT ABORT PRIMARY KEY, [descr] NVARCHAR(40), [marca] NVARCHAR(20), [codigoint] NVARCHAR(20), [preco] NUMERIC(5, 7), [preco2] NUMERIC(5, 7));
CREATE TABLE [pcdesc] ( [codigo] NVARCHAR(20), [qtde] NUMERIC(5, 6), [loja] INTEGER, [secao] INTEGER, [coletor] INTEGER, [hora] NVARCHAR(8), [dia] NVARCHAR(8), [chave] GUID PRIMARY KEY); This "Select " is ok. SELECT SUM(qtde) AS cont, codigo FROM pcdesc GROUP BY codigo" But I need the fields "*marca*" and "*descr*". select SUM(qtde) AS cont, descr , codigo FROM pcdesc GROUP BY codigo, descr ????? Wrong..... Thanks a lot, Ernany _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
