SQL - How do I get multiple values from another table to fit in a single row in a select statement?
SQL doesn't really deal in hierarchical data, it deals in sets. This is something better handled in 2 queries - one that returns the course information, and one that returns the students in the course.
Look up user defined aggregate functions. If you really need to list them all in one column, you can set up an aggregate function, and it will do that for you.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
SQL: select random row from table where the ID of the row isn't in another table?
SQL Server - Select Multiple Rows Data From One Table And Update Multiple Rows Data On Another Table With First Selected Data?
Is there a way I can select multiple rows in MYSQL based on the IDs saved in another row of another table?
Trouble creating a sql statement select statement reference same table twice?
Updating a table with multiple values from a select statement where the date matches?
Can I add values to a MySQL table via a form based on a match between values in a textbox and values in a column in the table?