Datamapper (Find rows NOT in my join table)

[eluser]tdktank59[/eluser]
well 1 option is to do something like this

Code:

$u = new User();
$u->where('id',$id);
$u->projects()->get();

foreach ($u->projects->all as $projects)
{
$project_ids = array($projects->id);
}

$p = new Project();
$p->where_not_in('id',$project_ids)->get();

see where im going with this?