Baruch Burstein <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
