Peter Otten wrote: > If the data stems from a database you can run (untested) > > select B.village_id, sum(A.adop_count) from A inner join B on A.person_id > = B.person_id; >
Oops, I forgot the group-by clause: select B.village_id, sum(A.adop_count) from A inner join B on A.person_id = B.person_id group by B.village_id; -- https://mail.python.org/mailman/listinfo/python-list
