You can create one stored procedure and in same stored procedure you can declare one table variable, you can insert result sets of both queries into this table variable.
After inserting data to your table variable you can select record from table variable.
Code snippet for declaring and inserting data to table variable is as below
DECLARE @ProductTotals TABLE
(
ProductID int,
Revenue money
)
INSERT INTO @ProductTotals (ProductID, Revenue)
SELECT ProductID, SUM(UnitPrice * Quantity)
FROM OrderDetails1
GROUP BY ProductID
INSERT INTO @ProductTotals (ProductID, Revenue)
SELECT ProductID, SUM(UnitPrice * Quantity)
FROM OrderDetails2
GROUP BY ProductID
SELECT * FROM @ProductTotals
This T-SQL code snippet is for your reference only, change your datatype and column name of
table variable as per your need
Hope this will help you. If it works fine accept the solution otherwise revert back to me with your queries.
Thanks