How to write join query in CodeIgniter?

1.	How to write join query in CodeIgniter?
Answer» $this-&GT;DB->JOIN('blog', 'comment.blog_id= blog.id', 'inner'); OR $this->db->join('blog', 'comment.blog_id= blog.id');

Discussion