Re: sql question if I may

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Wed, 8 Jan 2003 10:04:37 +0500
Message-ID: <avgbhe$f5b2j$1@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 Tue Jan 07 2003 - 23:04:37 CST