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
