How to pick latest moment on a day and lose rest of records?

[hansdevr]

I have a table with multiple accountnumbers. Here is only one, of many more. As you can see, there can be several mutations in the Cumulative amount per day. What I want is a table that lists just one day at a time, with the cumulative amount that was present at the latest time of that day. The rest can be discarded.

Any help would be much appreciated!

[marcus_sommer]

A join is a method to merge tables over one or several key-fields (fields with the same fieldname are key-fields) and all further existing fields from the join-load will be added to the first table. For this there are different variants like left/right/inner/outer which define how the tables will be merged - you will find some examples of them within the help.

In this case worked the inner join like a where-clause.

Only(Field) will only in very few cases a difference to loading the Field directly but you will need a group by statement for this and the load-times for such an aggregation-load will be much longer then by a normal table-load.

- Marcus