Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql question if I may

sql question if I may

From: Jerry D <jdubuke_at_notme.gpdservices.com>
Date: Tue, 7 Jan 2003 14:50:27 -0500
Message-ID: <3e1b3059$0$17893$724ebb72@reader2.ash.ops.us.uu.net>


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. Received on Tue Jan 07 2003 - 13:50:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US