Yes that works. But it is ambigous ... -----Ursprüngliche Nachricht----- Von: Igor Tandetnik <itandet...@mvps.org> Gesendet: 01.05.2010 16:00:01 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] sqlite update with joins
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 ___________________________________________________________ NEU: WEB.DE DSL für 19,99 EUR/mtl. und ohne Mindest-Laufzeit! http://produkte.web.de/go/02/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
