Comments by one user on another's posts

1

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 Comments.postID [Post Link], Posts.PostTypeId, Comments.Score, Comments.Text
FROM 
    Comments, Posts
WHERE Comments.UserId = ##UserId1##
AND   Posts.Id = Comments.postID
AND   Posts.OwnerUserId =  ##UserId2##
-- AND Text LIKE '%base%'
--ORDER BY Score Desc

Enter Parameters

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