Octavian Rasnita wrote: > So is it not possible to create the following query with DBIC? > > SELECT me.id, blogs.id, blog_comments.id > FROM user me LEFT JOIN blog blogs ON blogs.user = me.id > LEFT JOIN blog_comment blog_comments ON blog_comments.blog = blogs.id;
Yes, but if you want to spend your life designing queries - you don't need an ORM. It's also half the equation as the query doesn't define how that maps back into objects. > Can you please tell me how to do that? Peter Rabbitson already answered you: http://lists.scsys.co.uk/pipermail/dbix-class/2010-January/008804.html Carl _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk