SQL complex subquery, horizontal merge result set

Result set of the first query

Select* from(SelectC.msname,a.msid,c.msprice, C.msprice*count (A.MSID) asTotalmoney,sum (A.msamount) asTotalCount fromBillconsume a RIGHT join (SelectTop1Mstime asStarttime,getdate () asEndTime fromBillconsumewhereDateDiff (Dd,mstime,getdate ()) =0ORDER BY mstime ASC) b on a.mstime between B.starttime and B.endtime and a.msid!=0Left join Menus C on C.msid=a.msid GROUP by A.msid, C.msname,c.msprice) s

A statement that connects two result sets

Result set of the second query

(SelectSUM (T.totalmoney) asAlltotalmoney from ( SelectC.msname,a.msid,c.msprice, C.msprice*count (A.MSID) asTotalmoney,sum (A.msamount) asTotalCount fromBillconsume a RIGHT join (SelectTop1Mstime asStarttime,getdate () asEndTime fromBillconsumewhereDateDiff (Dd,mstime,getdate ()) =0ORDER BY mstime ASC) b on a.mstime between B.starttime and B.endtime and a.msid!=0Left join Menus C on C.msid=a.msid GROUP by A.msid, C.msname,c.msprice) t) t

Conditions for a linked table

1=1

SQL complex subquery, horizontal merge result set