Hi, Can someone please point me in the direction of the SQLite syntax structure for updating a table by joining to itself. I need to update one row with the contents of another.
Based on my normal database (Teradata) I was looking for something like update t1 from (select c1,c2 from t1) as dt1 set c2 = dt1.c2 where t1.c1 = dt1.c2 - 1; Or update t1 as a set c2 = t1.c2 where a.c1 = t1.c2 - 1; I can't see either of these syntax options in the documentation. All pointers greatly appreciated. Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: <http://www.ward-analytics.com> http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR Registered company number: 3917021 Registered in England and Wales. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
