Please have a look

[sote]

I want to list the students who select courses that somebody selectstable:student(id,name),course(id,name),student_course(studentid,courseid)thank you!

[Kcarson]

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.

[Skemcin]

This is answered here:http://w3schools.invisionzone.com/index.php?showtopic=687

[vijay]

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 ?

[sote]

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)

[Skemcin]

This is answered here:http://w3schools.invisionzone.com/index.php?showtopic=687

^^^^^^^^^^^^^^^^^^^(need moderator to lock this post)