comments on posts, by post owner first name

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
p.id as [Post Link], c.text
from users u
join posts p
on p.owneruserid = u.id
join comments c
on c.postid = p.id
where (u.displayname like 'Sarah %' or u.displayname = 'Sarah')
and c.id % 10 = 0

Enter Parameters

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