I need to write a query that returns the latest message in a conversation between two users. I've included the schema and my (failed) attempts in this fiddle: http://sqlfiddle.com/#!15/322c3/11
I've been working around the problem for some time now but every time I run any of my ugly queries a sweet little kitten dies.
Any help would be much appreciated. Do it for the kittens.