Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: multiple entries

    i'm a newb on this forum so i want to apologize if this has been discussed already. I'll try to explain my situation as best as i can.

    What i'd like to do is have a student table and a class table. I would like to have mutiple classes for one student. As a query i would like to show all the classes taken by particular student. The classes table needs to be easily updated. I'm new sql, so i'm having trouble creating a good database. Any help would be appreciated.


    Thanks
    sam

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: multiple entries

    Originally posted by suprthug8d
    i'm a newb on this forum so i want to apologize if this has been discussed already. I'll try to explain my situation as best as i can.

    What i'd like to do is have a student table and a class table. I would like to have mutiple classes for one student. As a query i would like to show all the classes taken by particular student. The classes table needs to be easily updated. I'm new sql, so i'm having trouble creating a good database. Any help would be appreciated.


    Thanks
    sam
    Try to find good documentation or buy some good SQL related book.
    Here are exmple urls:
    http://www.w3schools.com/sql/default.asp
    http://www.campus.ncl.ac.uk/databases/design/

    If you dont't like these urls, try to search in google.
    This forum is for solving the real troubles and problems not for teaching.

Posting Permissions

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