Re: odd sub-select problem

> >SELECT NAME FROM A
> >WHERE NAME IN (SELECT NAME FROM A)
>
> There must be a typo :-)
>
> You should try "minus", it could be more efficient.
> As for your question, are you names unique ?

Yes, that was definitely a typo...doh

And I think you've answered my question and solved my problem - the names are *not* unique, and using 'minus' seems to be working. Thanks! Received on Mon Oct 29 2001 - 16:32:58 CST