Baruch Burstein <bmburst...@gmail.com> wrote: > Does sqlite not support table aliases in update statements?
Indeed it does not. > 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); update table1 set col1 = col1 * 2 where col1 <= ( select avg(col1) from table1 t2 where table1.col2=t2.col2); "table1" prefix binds to the first occurrence of this table in the statement, in the outer UPDATE clause. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users