What is wrong with my SQL statement?

[eluser]vrencianz[/eluser]
Use join, as described here: http://ellislab.com/codeigniter/user-gui...tml#select

Code:

$this->db->select('*');
$this->db->from('lists');
$this->db->join('your_lists', 'your_lists.list_id = lists.id');

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