|
|
|
Re: Put data from one field to another. [message #671173 is a reply to message #671146] |
Thu, 16 August 2018 10:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/de0c2ca55f2e44bf542dc974e925b69c?s=64&d=mm&r=g) |
twardybidon
Messages: 2 Registered: August 2018
|
Junior Member |
|
|
Hi guys,
thanks for quick response and for the welcome message . Back to the query, the thing is that I have more than just one entries like this in the table.
I uploaded the screenshot once again. On the left side is what I fetched from the db. On the right side is what I would like to see as a result.
As you can see the entries where IDCONTAINER is not null are connected with this field where IDCONTAINER is null but IDCONTAINER from previous row equals to IDTSU.
example:
IDCONTAINER in second row = 903000110, idtsu = 903000111, weight =0 and height =0
and this is connected with first row
idcontainer = 0, IDTSU = 903000110, weight = 172, height = 2150.
and these weights and heights I would like to see in linked fields.
![https://image.ibb.co/moCfaz/weight_height.png](https://image.ibb.co/moCfaz/weight_height.png)
So max function is not in use here I think, because I've got around 3000 entries like this in that table.
[Updated on: Thu, 16 August 2018 10:27] Report message to a moderator
|
|
|
|
|