Suppose we have two tables. Post and Comment. Post has many Comments. Pretend they are somewhat filled so that the number of comments per post is varied. I want a query which will grab all posts but only the newest comment per post.

I have been directed to joins and sub queries but I can't figure it out.

Example Output:

Post1:
Comment4 (newest for post1)

Post2:
Comment2 (newest for post2)

Post3:
Comment 10 (newest for post3)

etc...

Any help would be greatly appreciated. Thanks.