--- "Downey, Shawn" <[EMAIL PROTECTED]> wrote:
> What is the correct SQL syntax for deleting records from > a single table > based on a where clause with multiple table references? > > > > For example: > > > > Sqlite> DELETE from timeline where > timeline.name=del_timelines.name and > timeline.last_change<=del_timelines.last_change; > How about something like: DELETE from timeline where rowid in (select t.rowid from timeline t, del_timelines d where t.name = d.name and t.last_change <= d.last_change); -Clark
