I am able to update a table with the values for the equivalent rows in another table (which has exactly the same fields as the first table). The query I’m using is working well, except for when there are more than 1 row per day for a specific car, in that case it will always update with the first value in the table for each car, instead of the last most updated value.
The query looks like this:
Table structure
The table plancar can hold multiple rows per car and day, while the tbl_cars only hold each car once per day.
How can I retrieve the latest row per car and day from the plancar table in order to set that value?