[Solved] Generate payment from more than 1 columns in SQL
[ad_1] Try this query : select OrderId, CustomerName, sum(ProductAmount*Price) as Total from Order O inner join OrderDetail OD on O.Id = OD.Id group by OrderID, CustomerName [ad_2] solved Generate payment from more than 1 columns in SQL