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 tried db(query).delete(join =...), but in this case join is not > supported. Should it be the way to go? > --
