On 2/05/2009 4:21 PM, Ernany wrote:
> 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.....
There is no column named "descr" in the "pcdesc" table. What error code
or message did you get from your (unspecified) interface? What did you
not understand about the error code or message?
The command-line executable "sqlite3" tells you rather explicitly:
sqlite> 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);
sqlite> SELECT SUM(qtde) AS cont, codigo FROM pcdesc GROUP BY codigo;
sqlite> select SUM(qtde) AS cont, descr , codigo FROM pcdesc GROUP BY
codigo,
...> descr;
SQL error: no such column: descr
sqlite>
By the way, those brackets around the column names are quite unnecessary
(your first SQL statement works OK withouit them, doesn't it?) and are
NOT standard SQL.
HTH,
John
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
