"Keith Medcalf" wrote...
BEGIN; INSERT OR REPLACE INTO LSOpenProjects SELECT * FROM client.LSOpenProjects as A WHERE A.ProjID <= 133560 AND Date != A.Date AND A.login = 'user1'; END;I presume that LSOpenProjects in both databases has a unique constraint on ProjID, Date, and login ...
Indeed. Thanks so much.josé
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users