|
|
|
Re: Put data from one field to another. [message #671173 is a reply to message #671146] |
Thu, 16 August 2018 10:27 |
|
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.
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
|
|
|
|
|