Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    87

    Unanswered: problem of getting name of the second director

    Hi everybody have two tables first is the member table with fields
    memberid,
    firstname,
    familyname

    The second is the course table
    courseid
    memberid
    memberid2

    SELECT (familyname + firstname) firstmembername
    from member inner join course ON member.memberid=course.memberid

    The above query just get the firstmembername of the first relationship with meberid... how could i get the familyname and firstname of memberid2 using the same query

    thanks for the help

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Because you have a flawed design (heaven help you if more than two memebers can be on a course) you need to join to the member table twice.

    First normal form - Wikipedia, the free encyclopedia
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Aug 2006
    Posts
    87
    Thanks yes i need to modify the table design for that... Thanks anyway

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •