forgot to mention

Forgot to mention - oracle 8.1.5 on AIX 4.2.3

Doug Cowles wrote:

> A developer gave me a query to tune up today using a syntax I'm not
> familiar with.
> On top of that, it doesn't appear to work right either. However, it
> produces no error
> message. Given 2 tables like
> create table A( a number);
> create table B( b number), with some values in them, the query did
> something like this
> (among other things)..
> select a from A
> where a != any
> (select b from B);
> It would appear to be an attempt to strip out values that appear in B,
> sort of a substitute
> for "not in". But as I said, it actually doesn't strip out anything,
> but doesn't generate
> any errors.
>
> So, is this some ANSI thing that compiles but doesn't work? Or maybe
> it's intended for
> another use and isn't being implemented right in this example?
>
> Any comments appreciated,
> Thanks,
> Dc.
Received on Thu Jan 27 2000 - 15:02:12 CST