Re: Update table.

On 19 Sep 2002 04:40:43 -0700, kenneth.osenbroch_at_canaldigital.com (Kenneth Osenbroch) wrote:

>kenneth.osenbroch_at_canaldigital.com (Kenneth Osenbroch) wrote in message news:<9c941a28.0209180407.333dcdf6_at_posting.google.com>...
>> Greetings.
>>
>> Hopefully, some of you can help me with the following scenario:
>>
>> Table A : Column A | Column B
>> . | .
>> Value 4 | Value 5
>> Value 6 | Value 7
>> Value 8 | Value 9
>> . | .
>>
>> I need to uptdate Table A to become:
>>
>> Table A : Column A | Column B
>> . | Value 4
>> Value 4 | Value 6
>> Value 6 | Value 8
>> Value 8 | .
>>
>> Ergo, I need to take the value from the the first row and update the
>> secound row - 1 with it. Any ideas on how to do this?
>>
>> Thanks,
>> Kenneth
>
>Thanks for the reply guys.
>
>I think I need to clarify the mentioned scenario a litle further. The
>thing is that each record in Column A consists of a character (one
>single character), and therefor it can't be unique (sorry to have left
>out this information in my first posting).
>
>So, what I need is to fetch the value from ex. record 3 in row 1 to
>record 2 in row 2. I think it will be the same scenario as mentioned
>earlier, bur without the possibility to substract a numeric value.
>
>Is this possible?
>
>Thanks,
>Kenneth

Without a unique key, what defines "record 1" or "row 1"?

Actually, what do you mean by 'record 3 in row 1'? Some of us older guys will use the terms 'record' and 'row' interchangeably (reflecting our pre-relational days), but I have no idea what is meant by a 'record' IN a 'row.'

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)