@Dantemss - Thank you. Subquery doesn't quite work as we need to sort by student last_name, status etc.,  Perhaps the user join needs to be hand-coded instead of generated.  Will try doing that today.