Re: sql question if I may

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
need
> > is from PS - ps_imkey.
> >
>
>
>
Received on Wed Jan 08 2003 - 06:35:11 CST