0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT TOP 1000
  q.Id AS QuestionId,
  q.Title AS QuestionTitle,
  q.Body AS QuestionBody,
  q.CreationDate AS QuestionCreationDate,
  q.Tags AS QuestionTags,
  q.AcceptedAnswerId,
  a.Id AS AnswerId,
  a.Body AS AnswerBody,
  a.CreationDate AS AnswerCreationDate,
  a.Score AS AnswerScore
FROM 
  Posts AS q
LEFT JOIN 
  Posts AS a
ON 
  q.AcceptedAnswerId = a.Id
WHERE 
  q.Tags LIKE '%<informatica>%'
  AND q.PostTypeId = 1  -- Ensures we're selecting questions
ORDER BY 
  q.CreationDate DESC;

view current version

edited sep 13

created sep 13 Shree.Guru.S