Returning 1 account row with values from additional tables

[mindbender]

what I am trying to do is return the most recent data for the accounts. So if there are multiple activities for each account the query will only return the most recent.



I have attached what my query looks like. The group by query seems to only retun the last modified date for the account but when I join it I get multiple account rows returning.

Any help woudl be awesome

[mindbender]

here is the attachment