Help with Query

From: spacejunk (anonymous_at_discussions.microsoft.com)
Date: 07/20/04

  • Next message: Steve Kass: "Re: Help with Query" 
    Date: Tue, 20 Jul 2004 11:52:58 -0700

    I have two columns I want to compare, both varchar, and
    would be in this format

    Subject | Instructor
    ----------------------
    ACCT101-nnnnn | jcdoe
    ACCT101-nnnnn | jcdoe
    ACCT102-nnnnn | jcdoe
    ACCT102-nnnnn | jcsmith
    ----------------------

    The subject is made up of (Table.Subject + '-' +
    CourseNumber)

    What I want to do, is query for those cases where the
    Table.Subject(ie ACCT101)has the same instructor for each
    instance. So if one teacher was teaching the same
    section of the course my query would be like this, from
    the above example:

    Subject | Instructor
    ----------------------
    ACCT101 | jcdoe
    ----------------------

    Does anyone know how I could do this?

    Thanks.

  • Next message: Steve Kass: "Re: Help with Query"