Clemens Ladisch wrote...
On 07/26/2014 06:22 AM, jose isaias cabrera wrote:
INSERT OR REPLACE INTO LSOpenProjects
SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date !=
A.Date;
What is A?
Sorry, this should have been written like this.
INSERT OR REPLACE INTO LSOpenProjects
SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date !=
'2014-04-23';
the id and the date is grabbed from the first step:
Step 1: prepare and execute this command,
SELECT id,Date FROM LSOpenProjects WHERE login != 'user1';
Then, I will create a huge SQL command using the data grabbed from step one.
thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
