Re: sql question if I may

Hi Jerry,

now I'm understanding no more than it was before :)

> What I need to do is to update the description field in the RQ table with
> the actual parent part from the PS table.
which one is ACTUAL part? Show on my example where we have values of 7 and 6 for the same ps_cpkey.

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com



> Since this is a one-time occurrence, I *could* just use a PL script to get

> an array of items I would be interested in, and do it as a multiple-pass

> update to the RQ table, but - being inquisitive - I wanted to see if there

> was a single SQL that could do it.

>

> Hope this clears things up.

> "Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message

> news:avgbhe$f5b2j$1_at_ID-127142.news.dfncis.de...

> > Hi,

> >

> > let us know whether this is a possible case for table PS:

> > PS_CPKEY   PS_IMKEY

> > ----------       ----------

> >          4            7

> >          4            6

> > If `yes' then what exact value should we set rq_descr to?

> >

> > Regards,

> > --

> > Roman Mirzaitov

> > Brainbench MVP for Oracle Administration

> > www.brainbench.com

> >

> >

> > "Jerry D" <jdubuke_at_notme.gpdservices.com> wrote in message

> > news:3e1b3059$0$17893$724ebb72_at_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.

> > >

> >

> >

> >

>

>