Fran:
I believe what you are looking for is the "group by" column. If you "group
by" school, then the count of 0s and 1s will be grouped by school.
HTH
Stephen Sloan
----- Original Message -----
From: Fran Peck <[EMAIL PROTECTED]>
To: Mapinfo List (E-mail) <[EMAIL PROTECTED]>
Sent: Friday, August 20, 1999 5:59 PM
Subject: MI SQL question Obtaining counts
> I have a question for the list. I have gone into the archives and users
> guide and have found one part of this question, but not the full solution.
I
> have a table of students with a column of INOUTDIST, and in the column
there
> is an "I" if they are varianced but from in district, and an "O" if they
are
> varianced but they are from out of the district. I have joined this table
> to my school polygon service area table by school number to ultimately
> thematically map the information. My dilemma is this: I can get a count
> (frequency) of "I" and "O" and when I add schoolnum in there can get the
> number by school. BUT I am still missing something - the query returns
with
> a TOTAL of "I"s and "O"s for each school. I can add in a where clause with
> either "I" or "O", but cannot figure out how to get my query to breakdown
> the number of each for each school. I know I could take this into Access
and
> manipulate it, but would like to keep it in MI with all of my MI pertinent
> info if at all possible. Any and all suggestions greatly appreciated!
> Thanks in advance.
>
> Fran Peck
> Office of Research and Planning
> Peoria Unified School District
> 6330 W Thunderbird Rd
> Glendale, AZ 85306
> 623-486-6099
> Fax: 623-486-6111
> Email: [EMAIL PROTECTED]
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
