Re: "Not in" subquery

On Jun 6, 4:58 pm, fitzjarr..._at_cox.net wrote:
> On Jun 6, 3:46 pm, Amritha.Da..._at_gmail.com wrote:
>
>
>
> > On Jun 6, 4:44 pm, fitzjarr..._at_cox.net wrote:
>
> > > On Jun 6, 3:23 pm, Amritha.Da..._at_gmail.com wrote:
>
> > > > Hello,
>
> > > > Is there any alternative query to the below one?
>
> > > > update RTable set Reason = "XYZ"
> > > > Where FKey = 1234
> > > > and SFKey = 1
> > > > and Reason Is Null
> > > > and F_ID not in ( Select F_ID from RTable
> > > > Where FKey = 1234
> > > > and SFKey = 1
> > > > and TO_NUMBER(REL_CD) = 1
> > > > and Reason Is Null);
>
> > > > "not in" in the above query is taking alot of time and it is timing
> > > > out.
>
> > > > Please Advise.
>
> > > > Thanks
>
> > > Cross-posting doesn't help you get a faster response.
>
> > > David Fitzjarrell
>
> > Sorry. Please help me as it is urgent requirement.
>
> > Sorry again!
>
> > Thanks- Hide quoted text -
>
> > - Show quoted text -
>
> "Urgent" is not a newsgroup mantra. If this truly IS 'urgent'
> possibly you should pay a consultant to work on this on-site.
>
> David Fitzjarrell

Ok. My apologies! Received on Wed Jun 06 2007 - 23:11:37 CEST