0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who like playing board games, designing board games or modifying the rules of existing board games

WITH 
html_tags AS
(
  SELECT TagName, Id
  FROM Tags
  WHERE TagName LIKE '%html%'
),
css_tags AS
(
  SELECT TagName, Id
  FROM Tags
  WHERE TagName LIKE '%css%'
),
html_posts as
(
  SELECT *
  FROM PostTags
  JOIN html_tags
  ON PostTags.TagId = html_tags.Id
),
css_posts as
(
  SELECT *
  FROM PostTags
  JOIN css_tags
  ON PostTags.TagId = css_tags.Id
)
SELECT html_posts.PostId, html_posts.TagName, css_posts.TagName
FROM html_posts 
JOIN css_posts 
ON html_posts.PostId = css_posts.PostId
ORDER BY html_posts.PostId

fork query

edited dec 5 user28646684

created dec 5 anonymous