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) ? 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? --