Kbase P26945: Embedded Select statments and Syntax error (7587)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/4/2008 |
|
Status: Verified
SYMPTOM(s):
Error 7587 when running a query with embedded SELECT statments
Syntax error (7587)
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
FACT(s) (Environment):
Running following query:
SELECT DISTINCT D.prod_id,
(select param_value from temp where D.prod_id = prod_id
and param_id = 42) As A,
(select param_value from temp where D.prod_id = prod_id
and param_id = 44) As B
FROM temp D
WHERE D.prod_id LIKE 'A19ABC%';
Progress 9.1D
All Supported Operating Systems
CAUSE:
Embedded Select statments are not supported
FIX:
Modify the query as follows:
SELECT DISTINCT B.prod_id, B.CatalogDoc, C.TechDoc
FROM (SELECT prod_id, param_value CatalogDoc FROM temp
WHERE param_id = 42) B,
(SELECT prod_id, param_value TechDoc FROM temp
WHERE param_id = 44) C
WHERE B.prod_id LIKE 'A19ABC%'
AND B.prod_id = C.prod_id;