RE: [Emerald] SQL QUERY

Phil Taylor ( Phil@lansystems.co.uk )
Tue, 1 Feb 2000 16:30:11 -0000

That doesn't give him town though !!!!!

> -----Original Message-----
> From: Duane Schaub [mailto:dschaub@terraworld.net]
> Sent: 01 February 2000 16:23
> To: emerald@iea-software.com
> Subject: RE: [Emerald] SQL QUERY
>
>
> Try
>
> select zip, count(zip) from masteraccounts
> group by zip
>
> That will sort them nicely.
>
> Duane.
>
>

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart