Update with the join of date function

You cannot get the result with your sample data. You dates without second will have a many to many relation and it will not update correctly.