hi,

slight prob... if i have one table w/list of cust. zip's and one w/list of acc. #'s, how can i get acc's per zip??? if anyone could help, i've tried everything i know... (not to say that's alot)

Sorry, could you please explain what you are trying to do in a bit more detail? I can't understand what you are trying to do, so therefore can not help you

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

hi and thanx for the read Andy,

i apologize for the confusing question ... in my demog table i'm needing columns per column , my dilemma is i need to know how many account #'s(one column) i have at each zip code(the other column), i can get total of each, total of both, averages, etc. however total # of accounts per zipcode eludes me... any help at all would be greatly appreciated

hi, and thanx anyway Andy,

the answer was actually very simple, the following query got the results i needed, or at least a good start, see ya

SELECT DISTINCT "zip", total = SUM(1)
FROM "dbo"."CLDEMOG"
GROUP BY "zip"