Thanks for the comments, but I thought I provided enough info to properly show the tables and schema I've been trying to define. I'm missing something here, because I just for the life of me cannot make it work where I have: name -> has_many -> account -> has_one boxfolder relationship work. I provided example SQL which does what I want, but I can't get DBIx::Class to do the same thing for some reason. Do I need to provide a complete standalong SQLite example code to show this?