I'd like to translate a SQL statement:

UPDATE foo SET colA = bar.colB FROM bar WHERE foo.colC = bar.colC;

I get this far, but am not sure how to add the FROM:

stmt = foo_table.update()\
 .where( foo_table.c.colC == bar_table.c.colC )\
 .values( foo_table.c.colA = bar_table.c.colA )


What do I need to do here?

-- 
Jon

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to