• Put what you've already got in a Common Table Expression, then join to the Subject table to get SubName.

    John