[sqlalchemy] Re: select A join B where B is null

Thanks that ended up working. so a query like this would do it: session.query(JobInfo).filter(~JobInfo.Job.has() -- David Gardner Pipeline Tools Programmer, Sid the Science Kid Jim Henson Creature Shop dgard...@creatureshop.com --~--~-~--~~~---~--~~ You

[sqlalchemy] Re: select A join B where B is null

On Apr 6, 2009, at 8:11 PM, David Gardner wrote: I am trying to get all of the rows in table A that do not have a match in table B. I believe the problem is that I am using a text foreign key, and for the rows I am looking for the field will still have a value, it just won't match