Quoth Fadhel Al-Hashim <fad...@gmail.com>, on 2010-10-02 14:51:59 +0300: > trying A.x<>B.x AND A.y<>B.y AND A.z<>B.z would just > hang.
Huh? How are you using that expression? I'd use DELETE FROM a WHERE NOT EXISTS (SELECT * FROM b WHERE a.key = b.key) with a suitable composite equality in the subselect. > Is my data too big for SQLIte? is it really hanging or it could be taking 3 > days? Table A and (particularly) table B both have indices on those columns, right? ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users