Kbase P25317: SQL92: Query with several LEFT OUTER JOINs missing records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Query with several LEFT OUTER JOINs missing records
Query using using the syntax: X.colX = Y.colX (+).
SQL92 query
CAUSE:
Bug# 20030514-007
CAUSE:
This is a known issue being investigated by Development
FIX:
As a workaround, use the following syntax:
LEFT OUTER JOIN tableY Y
ON X.colX = Y.colX
Fixed with Progress Service Pack 9.1D07 or higher.