0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners of the art and science of signal, image and video processing

SELECT DISTINCT Posts.Tags,Posts.Title,Posts.Body, acc.body [accepted answer]
FROM Posts
left outer join posts acc on posts.acceptedanswerid = acc.id
inner join posttags pt on pt.postid = Posts.id
inner join tags t on pt.tagid = t.id
where t.tagname in ('c++','COBOL','Cobra') AND acc.body IS NOT NULL

fork query

created dec 11 17 anonymous