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

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

dpackerSIG

Guest
Is it possible to create a subquery using Progress SQL to show summarized child-level data in the same row as the parent? For example: Header table is SalesOrder, Detail table is SalesLine: SELECT SalesOrder.OrderNumber, SalesOrder.CustomerNumber, [Some SQL code to get the total of Qty * Unit Price for all related SalesLine records] FROM PUB.SalesOrder Thanks for any advice!

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