RE: Engagement away from home
You are viewing a single comment's thread:
I had a week off in this period. That must really have dented my stats!!
I do try to comment on other posts, I am not a fan of those who only ever reply but there are a lot of those kind of authors.
I have joined a table to itself before, usually when you make the table as an alias and nested selects. It isn't the most graceful.
select * from comments com1
where blah in (select * from blah)
And blah in/not in etc
But fuck it, yours works!! :0D
0
0
0.000
Yep I think your week off cost you here :)
Love me some nested selects for readability!
The issue is seemingly a lack of key to main post from the comments within.
Also, a comment has a depth > 1 and a parent author, but nothin to say it is a comment of this post which was written by this author.
Anyway, string query saves the day!
Good old string query, almost sounds like a sitcom!! :OD
I must try harder in the other commenting!