× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



MAPICS Colleagues,

I'm trying to write an SQL and I'm having a brain blockage.  Maybe you can 
help?

I have a list of a group of teachers across the state.   The table 
contains mulitple teachers for each school in the list.

Teacher Name            Address City            ST      ZIP School
John Doe                123 Main        Podunk          IL      66666 
Podunk Middle School
Jane  Deering           123 Main        Podunk          IL      66666 
Podunk Middle School
Joe Teacher             456 Maple       Bucktown        IL      66667 
Washington Elementary School
Sally Teacherette       789 Jefferson   Nowhere IL      66668 Eisenhower 
Middle School


Ok, with such a list, what I want to retrieve, using SQL, is a list of the 
first teacher in every school, along with their associated school name and 
address.
For some reason, I can't figure out how to make this work.   The table is 
on the PC and I'm using Access to perform the query (written with SQL).  I 
haven't tried yet on the AS/400.   I think I need to use the GROUP BY 
function, but then I don't know what else.

Can anyone give me a tip?


Michael G. Ellis
Information Systems International, Inc.
A Global ERP Consulting Firm
815-398-1670 x23
 
Choose ISI consultants to ensure consistently top quality implementation 
services at all levels of your organization.

"The Leader must himself believe that willing obedience always beats 
forced obedience, and that he can get this only by really knowing what 
should be done.......Also he must be ready to suffer more hardships than 
he asks of his soldiers, more fatigue, greater extremes of hot and cold. 
-- Xenophon

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.