V
vjp2.at
I am selecting from two voter lists, one before and one after
redistricting. I do an inner join on voter id#, and try to get a mapping
of the various districts from old to new by making it distinct.
THe problem is that some people moved within the list and are fouling up my
mapping by making their one move look like a redistricting. So I want to
select distinct only for more than five matches per precinct.
(I posted this earlier as count subselect).
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]
redistricting. I do an inner join on voter id#, and try to get a mapping
of the various districts from old to new by making it distinct.
THe problem is that some people moved within the list and are fouling up my
mapping by making their one move look like a redistricting. So I want to
select distinct only for more than five matches per precinct.
(I posted this earlier as count subselect).
- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]