TSQL命令- by与异类数据集的联合

I have a query that UNIONs two somewhat similar datasets, but they both have some columns that are not present in the other -- i.e. the columns have NULL values in the resulting UNION. The purpose of the UNION is to get the data in a friendly format for the software-side.I have a query that UNIONs two somewhat similar