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
