In my db, a Project has many Jobs. I have a query on Projects where I
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,
Are either of these possible with a single search on Projects? Currently
we're breaking it up into two queries.
Searchable Archive: http://firstname.lastname@example.org