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 ) Table T has the alias x in the outer update an the alias y in the inner select. This is not possible. Has someone an idea for a workaround ? Simon -----Ursprüngliche Nachricht----- Von: Pavel Ivanov <paiva...@gmail.com> Gesendet: 30.04.2010 21:38:54 An: General Discussion of SQLite Database <sqlite-users@sqlite.org> Betreff: Re: [sqlite] sqlite update with joins You could try UPDATE H SET filename = (select F.rowid from F where F.filename = H.filename); Pavel On Fri, Apr 30, 2010 at 3:25 PM, David Lyon <david_ly...@yahoo.com> wrote: > I know sqlite update with joins is not supported but I have heard work > arounds without the need for scripting. > > eg: > 2 tables H and F both join on FILENAME > I want to update h.FILENAME so its the same as the rowid of table F > > > sqlite3 F "update H h , F f set h.FILENAME=f.rowid where > h.FILENAME=f.FILENAME " > > is there an easy work around before I embark on scripting this > > > Thanks Again > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________________________ GRATIS: Movie-Flat mit über 300 Top-Videos. Für WEB.DE Nutzer dauerhaft kostenlos! Jetzt freischalten unter http://movieflat.web.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
