On Apr 18, 2007, at 11:43 AM, [EMAIL PROTECTED] wrote:
>
> Hi Guys,
>
> I am trying to do this simple update query :
>
> s=select([table1.c.mo_id],and_
> (table1.c.msisdn=="123",table2.c.mo_id==table1.c.mo_id))
> s2=table2.update(table2.c.mo_id.in_(s),values={"Del":"tut"})
>
try calling s.correlate(table2) after constructing "s". that will
force a correlation to that table.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---