RE: US Zip codes

Booth,

How many rows are you looking at? It would seem to me that:

Select OrderNo, ZipCode, Zip.State
>From Order
        join Zip
                on Order.ZipCode = Zip.ZipCode 

Would give you a list of orders and their associated zips and states. If
OrderVal was a field on the header:

Select Zip.State, sum(OrderVal)
>From Order
        join Zip
                on Order.ZipCode, Zip.ZipCode
Group by State

Would give you a list of states and the sales into each.

-Walden


------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: Booth Martin [mailto:Booth@xxxxxxxxxxxx] 
Sent: Monday, October 06, 2003 12:37 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: US Zip codes

Am I reading you right? That the first two digits 00 thru 99 could have a
state associated with it and be accurate? (I know 05 = Vermont for example).
Its OK if a few states have more than one set of digits, but that is not a
problem as I only wish to do a look up from the 2 digits. An array of 100
elements is not unmanageable. 
 
---------------------------------------------------------
Booth Martin http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Monday, October 06, 2003 11:05:19
To: Midrange Systems Technical Discussion
Subject: Re: US Zip codes
 
 
Jim,
 
according to my zccity file from worksright software, I found no zips that
span multiple states.
 
whoever said there were some, could you post an example?
 
rick
 
----original message----------
So does anyone have a true zip code file with State Code, to verify
which zip codes cross state lines?
Also, John - do you ever sell to Canada, Mexico, or anywhere else?
Be aware there are zip codes in some other countries that match 5 digit US
zip codes.
jim
 
 
.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.