He wants to update table Records using data from table Table2. Dusan.
Igor Tandetnik wrote: > "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 > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
