Re: [sqlite] Updating records from a SELECT that exists in the table

How about this? BEGIN; INSERT OR REPLACE INTO LSOpenProjects SELECT cl.* FROM client.LSOpenProjects cl JOIN LSOpenProjects ls ON (cl.ProjID = ls.ProjID AND cl.ProjID <= 133560 AND cl.XtraB >= '2014-08-07 00:00:00';); END; I used join query to get existing records in local DB instead of

[sqlite] Updating records from a SELECT that exists in the table

Greetings! Long story... But, I have to update a DB from another DB if the record in the DB to be updated contains that record. So, with an attached DB, ATTACH 'somedb.sqlite' as client; I execute this command, BEGIN; INSERT OR REPLACE INTO LSOpenProjects SELECT * FROM