您是否只想将结果放在同一张表中？只需执行以下操作：
SELECt FirstTable.*, SecondTable.LargestOrderFROM ( SELECt EmailAddress, Orders.OrderID, SUM(ItemPrice * Quantity) AS OrderTotal FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID JOIN OrderItems ON Orders.OrderID = OrderItems.OrderID GROUP BY EmailAddress, Orders.OrderID) as FirstTableJOIN ( SELECt EmailAddress, MAX(ItemPrice) as LargestOrder FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID JOIN OrderItems ON Orders.OrderID = OrderItems.OrderID GROUP BY EmailAddress) as OtherTable ON FirstTable.EmailAddress = OtherTable.EmailAddress
