in reply to Trouble with Join/Prefetch in DBIx::Class

As Mr. Muskrat said you can interate over the many records

my @persons = $schema->resultset( 'TblPerson' ) ->search( { LastName => 'Smith', FirstName => 'John' }, { prefetch => ['tbl_requests'] } ); foreach my $p (@persons) { printf " Name : %s SternID : %s PrefName: %s ", $p->LastName, $p->username, $p->PrefName; for ($p->tbl_requests){ printf " RID = %s Status = %s\n",$_->RID,$_->status; } }
poj