Mysql query - one row details, child rows

[eluser]boltsabre[/eluser]
Oh right, oppps, sorry, completely dismiss my above comment, a right join will return all rows from table b, so long as it has 'b.parent'... don't know what I was thinking, brain fade, long day at work here.

So let me get this right... want to get a blog post and its details (table a) AND all comments associated to that particular post (table b)?

If that's the case, run two queries, one to get the blog details, another to get its comments.