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 ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users