Query Problem (Multiple Tables)

[eluser]ywftdg[/eluser]
Wow, somehow answered this one my own, pulled this out my...

Code:

$this->db->where('field_id_8', $this->uri->segment(1));
$this->db->select('*');
$this->db->from('exp_weblog_data','exp_weblog_titles');
$this->db->join('exp_weblog_titles', 'exp_weblog_titles.entry_id = exp_weblog_data.entry_id');
$data['query']=$query = $this->db->get();