[Active Record] Selecting data problem

[eluser]Armchair Samurai[/eluser]
This should work but hasn't been tested:

Code:

$sql = '(SELECT child FROM category_relations)';

$this->db->select('id');
$this->db->where('categories.id NOT IN', $sql, FALSE);
$query = $this->db->get('categories');