SELECT c.id as [Comment Link] FROM posts p inner join com...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  c.id as [Comment Link]
FROM
  posts p
  inner join comments c on 
    c.postid = p.id
    and c.UserId = p.OwnerUserId
    and c.text like '%accept this answer%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results