Referencing or linking mysql tables

[eluser]sanir[/eluser]
Use join for that.

Code:

$this->db->select('*');
$this->db->from('blogs');
$this->db->join('comments', 'comments.id = blogs.id');

$query = $this->db->get();

// Produces:
// SELECT * FROM blogs
// JOIN comments ON comments.id = blogs.id

Thanks,
Nasir Ranta