Hi all! u = transactions_table.update().\ where(and_(transactions_table.c.commit_date==current_date, \ transactions_table.c.serial==serial, \ transactions_table.c.user_id==users_table.c.id, \ users_table.c.office_id==id)).\ values(rollback_date=current_date, rollback_time=current_time)
When I perform this query I get (ProgrammingError) missing FROM-clause entry for table "users". I use PostgreSQL and I can't find any postgres_from keyword argument in update() is it possible to add it, or where I have to look to try to implement it, or how to perform this query with sqlalchemy? Thanks a lot! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---