sote Posted November 18, 2005 Share Posted November 18, 2005 I want to list the students who select courses that somebody selectstable:student(id,name),course(id,name),student_course(studentid,courseid)thank you! Link to comment Share on other sites More sharing options...
Kcarson Posted November 18, 2005 Share Posted November 18, 2005 Can you rephrase the question?Are you suggesting that somebody will say: "I need a list of students who are taking course A"?If so, you need to obviously do a select statement with 2 sub-select statements, or joins, your preference. To guide you, follow this guideline.Select the course id based on the name of the course givenSelect the student id based on the id of the course aboveSelect the student name based on the id of the student aboveIf you work around with it and play with it you should be able to figure it out. If not, show me what you have figured out and I will help you some more. Link to comment Share on other sites More sharing options...
Skemcin Posted November 18, 2005 Share Posted November 18, 2005 This is answered here:http://w3schools.invisionzone.com/index.php?showtopic=687 Link to comment Share on other sites More sharing options...
vijay Posted November 18, 2005 Share Posted November 18, 2005 I want to list the students who select courses that somebody selectstable:student(id,name),course(id,name),student_course(studentid,courseid)thank you![color=blueBy this what u want to ask>?Specify What u wnat to select ? Link to comment Share on other sites More sharing options...
sote Posted November 18, 2005 Author Share Posted November 18, 2005 Thank you very much!My English is poor!I want to list the students who select courses that somebody(i.e sote) selectstable: student(id,name),course(id,name),student_course(studentid,courseid,mark) Link to comment Share on other sites More sharing options...
Skemcin Posted November 18, 2005 Share Posted November 18, 2005 This is answered here:http://w3schools.invisionzone.com/index.php?showtopic=687 ^^^^^^^^^^^^^^^^^^^(need moderator to lock this post) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now