Practica

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language

Q&A for linguists, teachers and students of the Ukrainian language

SELECT DISTINCT p.Id, p.Title, p.ViewCount, t.TagName, t2.TagName
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'

Enter Parameters

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