> >'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 ... No, I meant what I wrote, except for the difference in "lastchange" to "last_change". > But regardless, this form of the DELETE command does not (seem) to work > in SQLite. Perhaps it is not part of the SQL standard. That's quite possible. I didn't test it using SQLite, but that form *does* work on MS SQL Server.
