Query translation in Active Record format

[eluser]Alhazred[/eluser]
Here what I've tried

Code:

$this->db->select('c.id AS id, c.name AS name, t.name AS category');
$this->db->from('category c, tipo_category t');
$this->db->where('t.id','c.category');

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

I don't have any error, but that generates an empty result, while the SQL version finds 3 records.