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 sqlalchemy@googlegroups.com
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