select top 100 posts.title, comments.text from posts inne...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100 posts.title, comments.text from posts
inner join comments on posts.id = comments.postid
where posts.id = (select max(id) from posts)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results