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


To expand upon his answer, you need a one-to-one relationship or at least search conditions that result in only one TblRequest per TblPerson if you want it work the way you have it written. You could also loop through each of the tbl_requests to get the status.