michael reddick wrote: > something like this i think is what you're after... > > $schema->resultset('User')->search( > { items.id => { '!=' => undef }, > { > join => 'items' > group_by => 'me.id', > } > ); I think that would work, although using the "right" join type seems more natural and might be even more efficient. -- Bernhard Graf