He wants to update table Records using data from table Table2. Dusan.
Igor Tandetnik wrote: > "aj" <amjohnso...@gmail.com> wrote in > message > news:95d3c7350812201131l1cd87998k55595f77fecc0...@mail.gmail.com > >> I would like to use math with more then one table, for example >> I know how to do this >> >> >> (Factors & Potential = columns) >> >> UPDATE Records >> SET Factors= (Factors * Potential) >> >> but i don't know how with an additional table, i came up with >> >> >> UPDATE Records,Table2 >> SET Factors= (Factors * Potential Table2.Field23) >> > > This last statement makes no sense ot me. Could you describe, in plain > English, what it was supposed to achieve? > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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
