"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