wdl...@web.de wrote: > The general problem with this issue is that it is not possible > > to set an alias for the table in an update statement. > That should be implemented because otherwise some necessary statements are > not possible. > > e.g. > > update T x > set x.col1 = ( select sum(c) from T y where y.id = x.id )
update T set col1 = (select sum(c) from T y where y.id = T.id); Try it, it works. Identifier T binds to the first mention of the table, which happens to be the one in the outer UPDATE statement. Other instances of T may be referred to with aliases. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
