my @requests = $schema->resultset( 'TblPerson' )->search({ LastName => 'Smith', FirstName => 'John' }, { prefetch => 'tbl_requests' } ); foreach my $request (@requests) { print "Name: " . $request->LastName . ", " .$request->FirstName . "\n"; print "SternID: " . $request->username . "\n"; print "PrefName: " . $request->PrefName . "\n"; print "Status: " . $request->tbl_requests->status . " . "\n"; }