SELECT DISTINCT [Post Link] = Posts.Id , [Tags] = Posts.T...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

SELECT DISTINCT
  [Post Link] = Posts.Id
, [Tags] = Posts.Tags

FROM Posts
INNER JOIN PostTags ON Posts.Id = PostTags.PostId
INNER JOIN Tags ON Tags.Id = PostTags.TagId

WHERE Posts.PostTypeId = 1 -- Question
AND Tags.TagName IN ('sql-server', 't-sql')

Enter Parameters

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