0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

SELECT p.Id As [Post Link], p.Tags
FROM Posts p
  INNER JOIN PostTags pt ON p.Id = pt.PostId
WHERE 
  pt.TagId = 16957 --access-vba
  AND EXISTS (
    SELECT 1
    FROM PostTags pt2
    WHERE pt2.PostId = p.Id
    AND Not pt2.TagId IN(930, 1449) --vba, ms-access
    HAVING COUNT(*) >= 5 --Number of tags must be 5, not counting vba and ms-access
  )

fork query

edited jul 8 20

created jul 8 20 Erik A