Re: summing of my distance query

[Dan Buettner]

Hmmmm - 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
  WHERE a.zipcode = "94949"
AND      (3956 * (2 *
ASIN(SQRT(POWER(SIN(((a.latitude-b.latitude)*0.017453293)/2),2) +
COS(a.latitude*0.017453293) * COS(b.latitude*0.017453293) *
POWER(SIN(((a.longitude-b.longitude)*0.017453293)/2),2))))) <= 10

I have been bashing my head on that a bit, right now I get
ERROR 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP
columns is illegal if there is no GROUP BY clause

--
Dan Buettner

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]