Currently I have student's management database project going on. For a page which "list all students" I would wanna do a
Expand|Select|Wrap|Line Numbers
- SELECT * FROM tbl_students
ie: "Maths, English, Science"
In the case of joining the tables, i can simply join based on the student_id field, but that will give me more than 10 records if i had 10 students in the database. How will I go about joining and grouping them so that i have something like this:
Expand|Select|Wrap|Line Numbers
- id name subjects
- 1 John English, Maths
- 2 Doe Science, English