Re: Oracle Sub Query "not in" problem

Amritha.Datta_at_gmail.com wrote:
> Is there any alternative query to the below one?

If you want to alienate those who are willing to help you keep this up. There are at least a dozen alternatives to your original query and you received a perfectly good solution.

If you want someone else to do your job for you ... go to c.d.o.marketplace and offer a consulting fee. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org