Bryan wrote:
>
> Why can't I refer to a column with query.c at this point? The query
> already has columns in its c collection, and I don't want to have
> repeat string names of columns, it would be cleaner to say
> query.c.jobId than "jobId". I thought that query.c.jobId would simply
> generate
On Nov 10, 12:46 pm, "Michael Bayer" wrote:
> Bryan wrote:
>
> > Trying to append this to a select object:
> > "WHERE jobId IN (SELECT id FROM job WHERE number=1)"
>
> > So I do this:
> > query = select()
> > subq = select([job.c.id], job.c.number==1).as_scalar()
> > query = query.where
Bryan wrote:
>
> Trying to append this to a select object:
> "WHERE jobId IN (SELECT id FROM job WHERE number=1)"
>
> So I do this:
> query = select()
> subq = select([job.c.id], job.c.number==1).as_scalar()
> query = query.where(query.c.jobId.in_(subq))
>
> But that is not working: "Every