Re: sql question if I may

I think that you are going to have to write a plsql script to update the rq_desc values via a loop, I tried to do what you are trying in a test db I have and could not.

I don't think that there is a way to do this in SQL alone, but I'm sure more knowledgeable posters on the group will correct me if I'm wrong. There may be a way if it is a one to one relationship between the tables in question, but I'm not sure what it is. (but I am curious now!)

Perhaps if I have time later today I'll try again.

hth

Glen
> Hi Roman,
>
> It is possible for me to have this recordset, but the qualifier of "where
> rq_imkey in ..." would return only one of those rows.
>
> A little background. PS is a product structure table. PS_CPKEY is a
> child
> part and PK_IMKEY is a parent part. I could use the same lower level
> screw
> in 2 differing parents, so the answer is yes. The RQ table is a table of
> requirements containing manufacturing info, such as date reqd, qty, etc
> for
> each item. So once I tie in the RQ table, I would get one and only one
> resulting row from the inner select for each record in the outer select.
>
> What I need to do is to update the description field in the RQ table with
> the actual parent part from the PS table.
>
> 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 wether 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

>> > is from PS - ps_imkey.
>> >
>>
>>
>>