0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

-- Enter Query Title
-- Enter Query Description

SELECT child.Id
     , title = CASE child.PostTypeId
         WHEN 2 THEN 'Answer: ' + parent.Title 
         WHEN 1 THEN 'Question: '+ child.Title
       END
     FROM Posts child
LEFT OUTER JOIN Posts parent ON child.ParentId = parent.Id
WHERE child.Body LIKE '%incorrect%'
AND child.PostTypeId = 1

fork query

created feb 2 11 anonymous