Kbase P145544: SQL: Does the OpenEdge SQL support using Scalar Subqueries in the SELECT column list?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/30/2009 |
|
Status: Unverified
GOAL:
SQL: Does the OpenEdge SQL support using Scalar Subqueries in the SELECT column list?
GOAL:
Does the OpenEdge SQL support embedding Scalar Scalar Subqueries in the SELECT list?
GOAL:
Does the OpenEdge SQL support the following query:
SELECT CustNum, Name, (SELECT AVG(Amount) FROM PUB.Invoice WHERE PUB.Customer.Custnum = PUB.Invoive.CustNum)
FROM PUB.Customer
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
No, OpenEdge SQL does not yet support the use of Scalar Subqueries in the SELECT list.