My MS SQL tables A and B have one to many relation. One entry in table A can have multiple related entries in table B.
With the query below I get a list of records so that works.
Select A.accountname, B.actiondate from B inner join A on A.account=B.account
The output is like:
But I would like to get only the latest action dates only like in the output example below