Active Record select question

[eluser]Eric Barnes[/eluser]
Well I got it working. I had to go the join route.

Code:

$this->db->select('*');
            $this->db->from('articles');
            $this->db->join('article2cat', 'articles.a_id = article2cat.article_id', 'left');
            $this->db->where('category_id', $id);
            $this->db->where('a_display', 'Y');
            $query = $this->db->get();
            echo $this->db->last_query();
            return $query;