Now there are two table, table A
Material number Posting date base date base price
001 the 2020-02-01
002 the 2020-02-02
003 the 2020-02-03


Table B
Material number base date base price
001 2020-02-02 100
001 2020-02-04 80
002 2020-02-03 150
002 2020-02-06 120
002 2020-02-07 130



The base price is change fields, and now want to get to the floor and table B intending to date and synchronized to the table A, o great god answer

CodePudding user response:

Take which records?

CodePudding user response:

Take the floor price field

CodePudding user response:

You're going to get the material number phase at the same time intending to date the biggest one to update A table? Or added to A table?