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!
You can only use a column name or expression. An expression can be an aggregate (min/max) or scalar function such as year/replace/trim. Note that also means you can use hardcoded string values like
select "stringname" as 'column1'
No sub-queries.
You should work to find a way to avoid using a subquery. It seems possible from your example.
Etienne
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??
You can only use a column name or expression. An expression can be an aggregate (min/max) or scalar function such as year/replace/trim. Note that also means you can use hardcoded string values like
select "stringname" as 'column1'
No sub-queries.
You should work to find a way to avoid using a subquery. It seems possible from your example.
Etienne