[eluser]David Johansson[/eluser]
Active record isn't very good at handeling nested queries, but you could probably do something like:
Code:
$this->db->select('ISNULL(SELECT name FROM table2 WHERE id=`x`, `codeigniter` ) AS name', FALSE)->get('table');
But other than that there is no special way of making it...