SELECT ParentId, OwnerDisplayName, Body FROM Posts p IN...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

-- Enter Query Title
-- Enter Query Description


SELECT ParentId, OwnerDisplayName, Body FROM Posts p
INNER Join 
(SELECT p.id 
FROM Posts p
INNER JOIN PostTags pt
ON p.Id = pt.PostId
INNER JOIN Tags t
ON pt.TagId = t.Id
INNER JOIN
(SELECT PostId FROM PostTags pt
INNER JOIN Tags t
ON pt.TagId = t.Id
WHERE TagName = 'sql') As s
ON p.Id = s.PostId
WHERE t.TagName Like 'ms-access%') i
ON p.ParentID = i.Id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results