Tricky SQL query

[eluser]Sumon[/eluser]
Hopefully meet your requirement

Code:

SELECT conversations.*, conversations_posts.* FROM conversations
LEFT JOIN conversations_posts ON conversations.conversationid = conversations_posts.conversationid
WHERE conversations.teamid = 1
ORDER BY conversations_posts.postid DESC
LIMIT 0,1 //if you need last record only.

Or

Code:

SELECT conversations.*, conversations_posts.* FROM conversations
LEFT JOIN conversations_posts ON conversations.conversationid = conversations_posts.conversationid
WHERE conversations.teamid = 1
ORDER BY conversations_posts.created DESC