Here's one possibility.

Select

dw.day + ' ' +

(

Select sts.Subject + ' '

From SubjectToStudy sts

Where dw.WeekID = sts.WeekID

Order by WeekID

For XML Path ('')

) as list

From

DAYOFWEEK dw

;