"aj" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
