Jay Sprenkle a écrit :
Thanks Jay,the "not in" was the syntax I didn't know for adding the select query to the delete command.You're welcome. You can also do it with a join but it's not as clear and simple.
Perhaps the "Join" version is faster than "Not In" ??I read that "not" usually got bad performance ... But it was not about SQLite.
What do you think about ? cyrille.
