Re: [sqlite] An issue about using ORDER and GROUP

, compile by gcc(mingw) ps2. may u try concat() written by me http://wakka.myweb.hinet.net/sqlite3ext.zip 2007/10/14, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > Wakka <[EMAIL PROTECTED]> wrote: > > I get into trouble about using GROUP and ORDER. > > > > When I use GR

[sqlite] An issue about using ORDER and GROUP

I get into trouble about using GROUP and ORDER. When I use GROUP and ORDER together, aggregate function can't work, could someone explain it? ### create two table CREATE TABLE book (id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE); INSERT INTO book VALUES (0); INSERT INTO book VALUES (0); INSERT INTO