complex query

[eluser]Matthieu Fauveau[/eluser]

Code:

$this->db->select('b.item1, b.item2, c.item1, c.item2, etc...')->from('blogs b')->join('comments c', 'c.post_id = b.post_id')->get();

Something like that