http://qs321.pair.com?node_id=1207023


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

Because of your has_many relationship, there are many tbl_requests and you haven't specified which of the many you'd like to see the status. Whereas, your second bit of code starts with individual TblRequests and gets the status of each.

(Sorry for the brevity, as I'm "out the door" so to speak. I'm sure someone else will elaborate if I can't get back to do so)