Re: Bugreport: Outer Join plus correlated subquery is badly broken

[Sven K�hler]

select a.x, b.y, c.z from a, b, c
where a.x = b.x (+)
  and a.r = c.x (+)
  and c.z = 1799
  and exists (
select p.x from p, u
where p.x = a.x
  and p.s = u.x
  and u.t = 'text'
)

this seems to be oracle syntax, and you should try this query:
SELECT a.x, b.y, c.z FROM a LEFT JOIN b ON a.x=b.x
LEFT JOIN c ON a.r=c.x WHERE
c.z=1799 AND EXISTS
(SELECT * FROM p JOIN u ON p.s=u.x
WHERE p.x=a.x AND u.t='text')

This should work fine.

I think, SAPDB has got problems with the oracle-syntax (and i don't like that oracle-syntax personally).



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general