Sorry, ignore that, can see now that all is a reserved word. RBS
On Thu, Mar 14, 2019 at 12:30 AM Bart Smissaert <bart.smissa...@gmail.com> wrote: > Thanks; this works fine: > > select PLACE, > sum(ID not in (select ID from ATTENDED)), > count(ID) > from PERSONS group by PLACE > > But if I add the aliases I get: > > near "All": syntax error > Result of sqlite3_prepare16_v3: 1 > select PLACE, sum(ID not in (select ID from ATTENDED)) Not_Attended, > count(*) All from PERSONS group by PLACE > > Otherwise very neat indeed though! > > RBS > > > > On Thu, Mar 14, 2019 at 12:21 AM Igor Tandetnik <i...@tandetnik.org> > wrote: > >> On 3/13/2019 8:08 PM, Bart Smissaert wrote: >> > But I would like the result to be in 3 columns, so result in this case >> > would be: >> > >> > Place Not_Attended All >> > ------------------------------- >> > A 3 7 >> > B 2 3 >> >> Something like this (not tested): >> >> select PLACE, >> sum(ID not in (select ID from ATTENDED)) Not_Attended, >> count(*) All >> from PERSONS group by PLACE; >> >> -- >> Igor Tandetnik >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users