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 <[email protected]> Gesendet: 30.04.2010 21:38:54 An: General Discussion of SQLite Database <[email protected]> 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 <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
