On 7/14/05, Downey, Shawn <[EMAIL PROTECTED]> wrote:
>>> DELETE from timeline where timeline.name=del_timelines.name and
>>> timeline.last_change<=del_timelines.last_change;
...
>> 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.
As far as I know, it isn't.
The canonical way would be:
DELETE
FROM timeline t1
WHERE t1.ROWID IN (SELECT ROWID
FROM timeline t, del_timelines d
WHERE t.name = d.name
AND t.last_change <= d.last_change);
-austin
--
Austin Ziegler * [EMAIL PROTECTED]
* Alternate: [EMAIL PROTECTED]
