[Solved] Generate payment from more than 1 columns in SQL

by

[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