To add in the question; you will need to add in your
Question table to the
FROM / INNER JOIN
list "source" list.
To get
All of the questions and tags, you will need to remove the WHERE clause from the query.
Without knowing the table structures, I can only guess as to the exact column names; so this most likely would need to be touched up
SELECT q.ID, q.QuestionText
, t.Id ,t.Name, t.UrlSlug
FROM dbo.Question q
INNER JOIN dbo.QuestionTagMap qtm ON q.ID = qtm.Quest_ID
INNER JOIN dbo.Tag t ON qtm.Tag_Id = t.Id