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 "
update H set FILENAME=(select F.rowid from F where H.FILENAME=F.FILENAME); Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
