Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sql question if I may
Hi all,
I have a database with 3 tables:
rq - 200,471 rcds ps - 31,021 rcds im - 17,525 rcds
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