[sqlite] sqlite update with joins

[David Lyon]

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