Would appreciate some wise words, can't get my head around this one.
I have 3 tables:
Basically the student table contains all the info, the groups table lists a simple list of available groups and the group_assignments table lists details of which student belongs to which group.
I am currently returning a complete list of students with no problem but I would like to be able to include the student group details in the recordset and filter on it.
Simple enough if each student only belongs to one group but most of them belong to many. What would be the best approach?