SelectQuery help

From: Jin Lee (jinsle..mail.com)
Date: Fri Jan 14 2005 - 03:09:42 EST

  • Next message: Bryan Lewis: "Re: SelectQuery help"

    Hey all,

    I have these three tables:

    Person (personid, name)
    PersonRole (roleid, personid)
    Role (roleid, rolename)

    Where Person has 1-many PersonRole and PersonRole has 1-1 Role

    I used the modeler to establish the relationships. What is the proper
    SelectQuery for selecting Persons with rolename equal to a certain
    role (such as "employee")

    Any help is greatly appreciated.

    Thanks,

    Jin

    This archive was generated by hypermail 2.0.0 : Fri Jan 14 2005 - 03:09:43 EST