mysql - Getting the max value after being multiplied and added

Question

please help me with the codes I'm working with right now. I just want to show the distinct Max value from the table After being multiplied and added the the 2 columns from 2 different tables.

HERE is my SQL statement for my table:

SELECT ol.*
     , SUM((ol.OrderedQuantity)*(SELECT p.ProductStandardPrice FROM product_t p WHERE p.ProductID=ol.ProductID)) AS TotalAmount  
  FROM orderline_t ol 
 GROUP 
    BY ol.OrderID

output table shows only the value inside the box using max.

question from:https://stackoverflow.com/questions/65857097/getting-the-max-value-after-being-multiplied-and-added

Answer 1

I don't follow exactly what you want to do. However, your query would more colloquially and accurately be written using JOIN. If you want the total per order then you don't want all those extraneous columns on the row:

SELECT ol.OrderId,
       SUM((ol.OrderedQuantity * p.ProductStandardPrice) AS TotalAmount  
FROM orderline_t ol JOIN
     product_t p 
     ON p.ProductID = ol.ProductID
GROUP BY ol.Order;

I suspect that starting with a working query will get you closer to the solution you want.