                       comment.contents,
                                  comment.reply_to_id,
                                  comment.user_id
                           from comment
                                    inner join replies
                                               on replies.comment_id = comment.reply_to_id)
select *
from replies;</code></pre>
<ul>
<li>If we need to include the original comment we are starting with in the result, we need a slightly different non-recursive term
<ul>
<l