Re: update table a.fkid from table b.pkid, additional information

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 14 Jul 2004 12:05:12 -0500
Message-ID: <0qpaf09se84d9u1vocdbna7v1at0j939sk@4ax.com>

"amwi" <amwi_at_yahoo.com> wrote:

>Forgot to mention:
>
>I use Oracle 10.1 and SQL *plus 10.1.
>
>Thanks for your help!
>
>"amwi" <amwi_at_yahoo.com> wrote in message
>news:DzaJc.98539$dP1.331950_at_newsc.telia.net...
>> I have tried to solve this on my own for a long time now, so i really need
>> som help here...
>>
>> How do i update table a.fkid from table b.pkid with the following "rule".
>> The table b.pkid's should be evenly distributed over table a.fkid's.
>>
>> Does anyone have a tip on how to solve this?
>> Thank you.
>>
>>
>

Define what you mean by 'table b.pkid's should be evenly distributed over table a.fkid's'..

For each a.fkid there should be a <specific> b.pkid ?

                                                              <at least 1>         ?
                                                             < a random>         ?

Received on Wed Jul 14 2004 - 12:05:12 CDT