Hello people, I have two SQL commands doing the same thing: 1. SELECT id FROM foo WHERE expr1 EXCEPT SELECT id FROM bar WHERE expr2
2. SELECT id FROM foo WHERE expr1 AND id not IN (SELECT id FTOM bar WHERE expr2) Can you say which one is faster? I prefer second option because I can use extra condition like LIMIT. -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users