Scott, I think you want something like this, then, assuming you still
want to limit by radius from a given ZIP.
SELECT b.zipcode,
sum( b.inc_level1 ), sum( b.inc_level2 ),
FROM zipcodes a, zipcodes b
WHERE a.zipcode = 94949
AND (3956 * (2 *
H - try adding a group by b.zipcode to the end ...
Dan
Scott Haneda wrote:
Scott, I think you want something like this, then, assuming you still
want to limit by radius from a given ZIP.
SELECT b.zipcode,
sum( b.inc_level1 ), sum( b.inc_level2 ),
FROM zipcodes a, zipcodes b
Mysql 4.0.18
++---+--+-+--++
| Field | Type | Null | Key | Default | Extra |
++---+--+-+--++
| id | int(11) | | PRI | NULL |
Scott, can you expound on what 1 row would be returned, ideally? The
one with the shortest distance? Or a row with the sums of inc_level1
... inc_level7 ?
Looks to me like you're trying to locate all the ZIP codes within a
given radius of (in this case) ZIP 94949 with the query below.
Scott, can you expound on what 1 row would be returned, ideally? The
one with the shortest distance? Or a row with the sums of inc_level1
... inc_level7 ?
Looks to me like you're trying to locate all the ZIP codes within a
given radius of (in this case) ZIP 94949 with the query below.
Scott, I think you want something like this, then, assuming you still
want to limit by radius from a given ZIP.
SELECT b.zipcode,
sum( b.inc_level1 ), sum( b.inc_level2 ),
FROM zipcodes a, zipcodes b
WHERE a.zipcode = 94949
AND (3956 * (2 *