On Apr 1, 2012, at 3:21 PM, Simon Slavin wrote: > Can this be done with a JOIN instead of a sub-SELECT ?
Not in SQLite, as the join clause is not supported in an update statement. For such functionality, look at MySQL or Postgress which do support variation of such syntax. Something like this would indeed be convenient: update foo set foo.fubar = foo.fubar * bar.fubar join bar on bar.baz = foo.baz But sadly, SQLite doesn't provide anything like this. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users