Given the following tables, is it possible to extract rows of class data along with all participating student names concatenated in one column in a single SQL query?
Classes-----------IDDateSubject Participants----------------IDClassIDStudentID Students------------IDName As always, thanks for any help on this!