Igor, what happens if there are multiple hits for SELECT frequency FROM beta WHERE beta.term = alpha.term
(there aren't but, it is possible for there to be). Rob could be right in a sense. On Wed, Sep 5, 2012 at 1:28 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > On 9/5/2012 4:20 PM, Rob Richardson wrote: > >> 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. >> > > No, that's not true. Every record in alpha will be updated exactly once. > -- > Igor Tandetnik > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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