>> 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

Reply via email to