Michael Bayer ha scritto: > On Feb 11, 2008, at 6:36 AM, Glauco wrote: > > >> Hi all, >> What's the simplest way for do a simple: >> >> select * from myTable where id in (1,2,3); >> >> >> >> I've solved this by using Subquery but final qry isn't pretty as >> this one. >> > > > mytable.select(mytable.c.id.in_([1,2,3])) > Thank you michael, i've lost the "in_" operator.
Glauco -- +------------------------------------------------------------+ Glauco Uri glauco(at)sferacarta.com Sfera Carta Software® info(at)sferacarta.com Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054 +------------------------------------------------------------+ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---