>> DELETE from timeline where timeline.name=del_timelines.name and >> timeline.last_change<=del_timelines.last_change; > >'Twere me, I'd do it like this: > > delete timeline > from del_timelines > where timeline.name = del_timelines.name > and timeline.lastchange <= del_timelines.last_change
I guess you mean ... from timeline,del_timeline ... But regardless, this form of the DELETE command does not (seem) to work in SQLite. Perhaps it is not part of the SQL standard. The SQLite documentation in http://www.sqlite.org/lang_delete.html states pretty clearly that the command starts with "DELETE FROM" (nothing between the "DELETE" and the "FROM"). sql-statement ::= DELETE FROM [database-name .] table-name [WHERE expr] The DELETE command is used to remove records from a table. The command consists of the "DELETE FROM" keywords followed by the name of the table from which records are to be removed. Without a WHERE clause, all rows of the table are removed. If a WHERE clause is supplied, then only those rows that match the expression are removed. -Shawn
