Well, I think you want a where clause on your main UPDATE query. What you wrote will set the frequency of every record in the alpha table to the value from the beta table, for every record in the beta table that matches an alpha record. (It's late, I'm tired and that's incoherent. I hope you followed it.) If you have 1000 records in the two tables that match each other, every record in the alpha table will be updated 1000 times.
Or am I merely demonstrating my ignorance? RobR -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of E. Timothy Uy Sent: Wednesday, September 05, 2012 4:11 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] classic update join question Dear Igor, Are you saying that UPDATE alpha SET frequency = (SELECT frequency FROM beta WHERE beta.term = alpha.term) is just as efficient as it gets and equivalent to an update using join (in other dbs)? That would helpful to know. I do kind of imagine some kind of black magic... ;) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
