With answers as ( SELECT top 10 Id, id [Post Link], postT...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

With answers as (
SELECT top 10
   Id,
   id [Post Link],
   postTypeId,
   OwnerUserID
FROM Posts p
WHERE postTypeID = 2)
SELECT * From answers a 
inner join comments c
ON a.id = c.postId
and a.owneruserid <> c.userid

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results