I have a question about using the DISCTINCT Keyword. Does anyone know which
record it takes... the first occurence? If so, does it still exhibit his
behavior over a sorted table?
For example, if one finds him/herself in a situation where one must select
one record from the many side of a one to many relationship, and this
selection depends on a field on the many side, can one sort by this field
and SELECT DISTINCT on the foreign key (we're assuming the absense of a
Student_ID, <other student-related fields>
Many-side table: ...