MySQL Forums
Forum List  »  Newbie

Re: multiple select and one insert?
Posted by: Barry Galbraith
Date: November 27, 2010 04:37PM

All you need to insert in your enrollment table is the 5 "id" values you have POSTed in.

You can display the data you require with
SELECT ... FROM student s
JOIN enrollment e ON s.studID = e.studID
JOIN course c ON e.courseID = c.courseID
JOIN session se e.sessionID = se.sessionID
...
...
WHERE s.studID = 86;

Good luck,
Barry.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.