my $min_phone_ids = $dbh->selectcol_arrayref("SELECT MIN(PhoneNumberID) FROM phone_numbers GROUP BY MemberID"); my $sql = <selectall_arrayref( $sql, {}, @$min_phone_ids );