Good day everyone. I have two tables that contain about 5 million records. I am trying to write an SQL command to delete rows from table A with PK (x,y,z) where PK (x,y,z) is not in table B.
tried using "NOT IN" but my PK is composite. trying A.x<>B.x AND A.y<>B.y AND A.z<>B.z would just hang. Is my data too big for SQLIte? is it really hanging or it could be taking 3 days? thank you, fadhel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users