[sqlalchemy] Subquery giving single values in the SELECT part of a query

2014-10-22 Thread Guido Winkelmann
Hi, How can I put a subquery that yields exactly one value inside the select part of the query without joining the subquery like another table? I have a table jobs and a table tasks. Every job has got any arbitrary number (zero or more) of tasks. Tasks can be in one of four states: queued,

Re: [sqlalchemy] Subquery giving single values in the SELECT part of a query

2014-10-22 Thread Michael Bayer
On Oct 22, 2014, at 11:36 AM, Guido Winkelmann gu...@ambient-entertainment.de wrote: Hi, How can I put a subquery that yields exactly one value inside the select part of the query without joining the subquery like another table? I have a table jobs and a table tasks. Every job has