>I can express
>
>select * from MyTable outside
> where exists
> ( select 1 from DiscountMaster inside where inside.active = 'N')
>
>
>??
>EXIST () is just EMPTY SET or NOT EMPTY SET. There is nothing said about correlation.
>
OK, point taken, so I'll paraphrase...I'm hard-pressed to think of any practical example where the subquery with an EXISTS will not be correlated. Correct, you can do that and it will execute, but beyond that, not sure anyone would write that :)