Oliver Peters <oliver.pet@...> writes: I definitely need glasses for my glasses
AS cnt_all_people belongs after COUNT(zip) so this is correct SELECT a.zip, a.cnt_people_in_town, b.cnt_all_people ( SELECT zip, COUNT(zip) AS cnt_people_in_town FROM people GROUP BY zip ) a CROSS JOIN ( SELECT COUNT(zip) AS cnt_all_people FROM people ) b ; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users