I'm working on a query that grabs a list of all the users plus the latest note for that user. The tables look something like this:

user: id | email
note: id | user | body | posted

So I try something like this, but the body and the posted date don't match

SELECT user.id, user.email, note.body, MAX(note.posted) FROM user JOIN note ON note.user = user.id GROUP BY user.id ORDER BY posted DESC LIMIT 20
Any ideas on how to get this to work would be appreciated.