Re: SQL statement with semi join in combination with minus operator cannot be parsed

jb wrote:
> Hello
>
> I have the following four tables "a", "b", "c" and "d". Table "a" and
> "b" are joined in combination with a semi join to "c" minus a semi join
> to "d". The example provided is only theoretical in order to reproduce
> my issue. I have tested it on Oracle 9.2.0.1.0 and Oracle 10.1.0.2.0
> for Windows.

I wrote a tirade against ANSI joins in the post less then 24 hours ago. Now you see why. Write this query as a decent and civilized join, not a @#$%$! ANSI join.

-- 
Mladen Gogala
http://www.mgogala.com