"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

Reply via email to