0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT DISTINCT p.Id, p.Title, p.ViewCount 
From Posts p 

    -- Camino 1
	INNER JOIN PostTags pt ON (p.id = pt.PostId)
		INNER JOIN Tags t ON (pt.TagId = t.Id) 
        
    -- Camino 2
    INNER JOIN PostTags pt2 ON (p.id = pt2.PostId)
		INNER JOIN Tags t2 ON (pt2.Tagid = t2.Id) 

WHERE p.ParentId is NULL 
  AND  t.TagName = 'relational' 
  AND t2.TagName = 'entity-relationship'

fork query

edited apr 17 Luis44376

created apr 16 anonymous