I have a user table with userID, userName ...the standards.
I also have a "Material" table with materialID, materialName, etc.
I combine these in another table "UsersMaterial" with userID and materialID, depending on which materials the user has chosen (between 0 and 5).
Now I need a stored procedure that returns the user information + the set of materials that is mapped to the user.
But I can't see how I can return one row of user information combined with a set of the user materials? Do I join or can I return a set + one row?
Thanks in advance!
View Complete Post