----- Original Message -----
From: "Josh Hillman" <admin-maillist@talstar.com>
To: <emerald@iea-software.com>
Sent: Tuesday, February 01, 2000 10:53
Subject: Re: [Emerald] SQL QUERY
> Here's something...
>
> SELECT City, ZIP, MBRs=count(Zip)
> FROM MasterAccounts
> WHERE Active = 1 /* Display only "active" people) */
> GROUP BY City, Zip
> ORDER BY City, Zip
>
> ----- Original Message -----
> From: PowerNet <psc5@powersupply.net>
> To: <emerald@iea-software.com>
> Sent: Tuesday, February 01, 2000 10:04 AM
> Subject: [Emerald] SQL QUERY
>
>
> I need a list of zip codes I service and # of users by zip.
>
> We are using Emerald/RadiusNt with SQL 6.5
>
> I am looking for a nice little script that will show me Town, Zip code and
#
> of users per.
>
> I would be happy to see any script close also.
>
> Thanks,
> John
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart