Symptom
A join query stated with a subquery used with NOT EXISTS (example 1) or a right outer join query (example 2)
with non-equality join condition may return wrong result.
* example 1:
select * from T1 as A1
where A1.account_id in (33712742, 33712768, 33712770)
and not exists(select 1 from T2 as A2
where A2.account_id = A1.account_id
and A2.START_DATE > A1.CLOSE_DT)
order by A1.account_id;
* example 2:
select * from T1 A1 left outer join T2 A2
on (A1.account_id = A2.account_id and A2.START_DATE > A1.CLOSE_DT)
where A1.account_id in (33712742, 33712768, 33712770)
order by A1.account_id;
Read more...
Environment
- SAP IQ16.0 SP11.20
-
SAP IQ16.1 SP02.15
Product
Keywords
Wrong result, "Not Exists", "outer Join", , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.