[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQL Query - question about subqueries

  • Thread starter Thread starter David Abdala
  • Start date Start date
Status
Not open for further replies.
D

David Abdala

Guest
I may not have understood the question, but you don't need subquerys for that: SELECT SalesOrder.OrderNumber, SUM(SalesLine.Qty * SalesLine.Price) AS GrandTotal FROM SalesOrder, SalesLine WHERE SalesOrder.OrderNumber = SalesLine.OrderNumber GROUP BY SalesOrder.OrderNumber Doesn't that works??

Continue reading...
 
Status
Not open for further replies.
Back
Top