Jump to content

Please have a look


sote
 Share

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...