Simon Slavin <slav...@bigfraud.org> wrote: > On 1 Apr 2012, at 2:09pm, Baruch Burstein <bmburst...@gmail.com> wrote: > >> Does sqlite not support table aliases in update statements? Is there a way >> to work around this to get the affect of >> >> update table1 t1 >> >> set col1 = col1 * 2 >> >> where col1 <= (select avg(col1) >> >> from table1 >> where col2=t1.col2); > > Can this be done with a JOIN instead of a sub-SELECT ?
If only SQLite allowed joins in an UPDATE statement. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
