Kbase P15781: Error (7588) when using Distinct twice in one SQL-92 Select statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/4/2008 |
|
Status: Verified
SYMPTOM(s):
Error (7588) when using Distinct twice in one SQL-92 Select statement
Distinct specified more than once in query (7588)
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
Enhancement Request# OE00084837
CAUSE:
Enhancement Request# OE00164942
CAUSE:
Enhancement Request# OE00046228
FIX:
This Enhancement has not been implemented in the product. As a workaround, create two database views and make the query based on these views. For example:
CREATE view1 (label1) AS COUNT(DISTINCT field1)
from table1;
CREATE view2 (label2) AS COUNT(DISTINCT field2)
from table1;
COMMIT;
SELECT label1, label2 from view2, view2;