Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql question if I may
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?
Received on Tue Jan 07 2003 - 15:24:22 CST