SQL Server将同一个表上的多个查询组合成单个resultset。

I've seen similar questions but can't quite find a solution to this problem. Bear with the mess of tables, as the question should be? fairly straightforward. I've seen similar questions but can't quite fin