Hi all,

In my db, a Project has many Jobs. I have a query on Projects where I want to:

1. Sort the jobs of each project by a particular column on the Jobs table
2. Only include jobs that satisfy some criterion, without excluding
   projects where no such jobs exist (i.e. add a condition to JOIN ON,
   not WHERE)

Are either of these possible with a single search on Projects? Currently we're breaking it up into two queries.

Shea Levy

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

Reply via email to