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; SQL error: no such column: del_timeline.name This is probably because I did not refer to the del_timelines table in the from clause. But I only want to delete only from the timelines table - not the del_timelines table. MySQL allows me a different syntax for DELETE: MySQL> DELETE timeline FROM timeline,del_timeline where .... But this alternate DELETE syntax does not seem to be allowed in sqlite. Thanks for any help. Schemas follow: CREATE TABLE timeline( name VARCHAR(32) not null, sim_time VARCHAR(10), perf_time VARCHAR(10), plot_time VARCHAR(10) , dmg_code VARCHAR(32) not null, dmg_type VARCHAR(1) not null, compt_id VARCHAR(16), item_id VARCHAR(16), neighbor VARCHAR(16), source VARCHAR(10), last_change INTEGER ); CREATE TABLE del_timelines( name VARCHAR(32) primary key not null, last_change INTEGER ); Shawn M. Downey MPR Associates 632 Plank Road, Suite 110 Clifton Park, NY 12065 518-371-3983 x3 (work) 860-508-5015 (cell)