I have a table for student records and a table for semester records. Each student can have many
semester records.

I need to produce a list of students with the last semester (there is a semester date field) that they
attended record. There should be only one record for each student.

I have been trying to use a group by query with a max for the semester date field, but it hasn't worked.
I am getting the same student listed over for as many times as they have semester records.

Either the joins are the wrong way around or select unique records.