[sqlite] Update SQLITE

[gideon.e]

I have the following SQLITE query :

 

SELECT

               BlokkeklaarAliasnaam,

               BlokkeklaarKultivar,

               sum(BlokkeklaarSkatting)

FROM

               Blokkeklaar

GROUP BY

               BlokkeklaarAliasnaam,

               BlokkeklaarKultivar;

 

 

I cannot figure out how to update a column (i.e.
BlokkeklaarSkattingKultAliasnaam) with the value of sum(BlokkeklaarSkatting)
in the above statement.

This refers to a single table.

 

Regards

 

 

 

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users