@Dantemss - I need to order by the resulting student exercises by the student last name and student status - so, having the students in the subquery won't be sufficient.  Does that make sense?