with query2 as
(
with query1as
(select OrderID,SUM(CONVERT (money,(unitprice*quantity*(1-discount))))
as OrderMoney from [Order Details]
group by orderid
)
select od.OrderID,od.OrderMoney,o.CustomerID,o.OrderDate
from query1 od inner join Orders oon od.OrderID =o.OrderID
)
select q.OrderID,q.OrderMoney,q.CustomerID,q.OrderDate,c.CompanyName
from query2 q inner join Customers c
on q.CustomerID =c.CustomerID
(
with query1as
(select OrderID,SUM(CONVERT (money,(unitprice*quantity*(1-discount))))
as OrderMoney from [Order Details]
group by orderid
)
select od.OrderID,od.OrderMoney,o.CustomerID,o.OrderDate
from query1 od inner join Orders oon od.OrderID =o.OrderID
)
select q.OrderID,q.OrderMoney,q.CustomerID,q.OrderDate,c.CompanyName
from query2 q inner join Customers c
on q.CustomerID =c.CustomerID