SELECT Top 10 Posts.Title, Tags.TagName, Tags.Count FROM ...

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 10 
  Posts.Title, 
  Tags.TagName,
  Tags.Count
FROM Posts
INNER JOIN PostTags on (
  Posts.Id = PostTags.PostId
) INNER Join Tags on (
  PostTags.TagId = Tags.Id
)

Enter Parameters

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