Hi MattLG,

have you thought about using

in your select?

In the doc DBIx::ResultSet::Cookbook under subselects.

Adapted from the doc you could do this (untested):

$items->search({ 'joined_table.column' => {-in => \@values } });
[download]