Please, a couple of queries...

John Lange ( )
Fri, 20 Mar 1998 10:25:35 -0600


Could one of you wonderful soles could write a couple of sql queries for me
I would be real grateful.

We need among others, 2 things.

1. We need total sub accounts by type subtotaled by city
Don't need to see each record, just # for each account type grouped and
totaled by city.

2. Same thing by Region

Doesn't have to print out in a report, just run in iSQL and report the info.

Thanks & really appreciated
JOhn :}

John C. Lange, Sr. PALACE dot NET, INC. MICRO-TECH Computers, Inc.
608.742.1601 & 6980 2800 New Pinery Road Portage, WI 53901
Visit our online store @
Authorized iPSwitch WebVar @

--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)