"Rich" <richmun_at_yahoo.com> wrote in message
news:XQ8B9.9933$%m4.2518_at_rwcrnsc52.ops.asp.att.net...
> OPS a couple 'o things........
>
> My code didn't conjur up the right results and......
>
> I'm also trying to exclude myself from the result set (RICH 406) also. So
I
> just want to get TOM as a result.
>
> thanks guys
Look into the not exists clause.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Nov 15 2002 - 10:09:30 CST
