Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql question if I may
"Glen A Stromquist" <glen_stromquist_at_nospam.yahoo.com> wrote in message
news:aAHS9.115804$k13.4620886_at_news0.telusplanet.net...
> Jerry D wrote:
>
> > Hi all,
> > I have a database with 3 tables:
> > rq - 200,471 rcds
> > ps - 31,021 rcds
> > im - 17,525 rcds
> > if i do the following query, I get the correct number of records:
> >
> > select rq_imkey
> > from rq
> > where rq_imkey in
> > (select ps_cpkey from ps, im
> > where im_key = ps_cpkey and
> > im_planner = 100);
> >
> > This returns 1844 rows, which is what I expect.
> > Now, I need to update a field in RQ - called rq_descr, and the info I
need
> > is from PS - ps_imkey.
> >
> > I cannot for the life of me figure out how to incorporate that piece of
> > info into my query.
> >
> > Could one of the SQL gurus out there assist me? Pleeeeaassseee???
> >
> > Jerry D.
> I'm not sure exactly what you need here, do you want to update the
rq_descr
> column in rq with data IN the ps.ps_imkey field, or update the rq_descr
> filed based on criteria in the ps.ps_imkey?
Ahhhh, sorry bout being not-so-clear!
I need the equiv of
set rq_descr = ps_imkey
surrounded by all the other good stuff....
no other criteria - need to update the aforenentioned 1844 rows...
Received on Tue Jan 07 2003 - 15:23:09 CST