> > db((db.keyword.id!=db.users_keywords.keyword_id)&(db.keyword.dictionary==dictionary)).delete(db.keyword) > > >
Exactly what set of records are you trying to delete from db.keyword? Are you trying to identify keywords that are not referenced by any records in db.users_keywords? If so, how about a nested select ( http://web2py.com/books/default/chapter/29/6#belongs): ids = db()._select(db.users_keywords.keyword_id, distinct=True) db((~db.keyword.id.belongs(ids)) & (db.keyword.dictionary == dictionary)). delete() Anthony
