[web2py] Re: delete query translation

It should. Please open a ticket and we will add it. On Monday, 14 January 2013 07:34:51 UTC-6, dederocks wrote: > > Hello, > > How do you translate the following in dal? > > delete tableA from tableA where TableA.field1='x' > join TableB on TableB.field2=TableA.field3 > WHERE (TableB.field3 = y) ?

[web2py] Re: delete query translation

Change the == on the field tests to single = db((tableA.field1='x') & (tableA.field3==TableB.field2) & (TableB.field3=y)).delete() Ron if you do db((tableA.field1=='x') & (tableA.field3==TableB.field2) & > (TableB.field3==y)).delete() it doesn't work -- too many tables selected. > I also trie