I can't seem to figure out how to tell sqlalchemy to do something like : UPDATE Foo SET turnover = 1 WHERE EXPLANATION NOT IN(SELECT Reason FROM mbsIsTurnoverXLAT where Datasource ='blah' and Isturnover=0) AND DATASOURCE = 'blah'
The "not in" clause is the part that's tripping me up. I'm not sure how to express that using the query api with raw Table objects. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
