Re: [sqlite] Math Update with two tables

"Dusan Gibarac" wrote in message news:4951940f@cbsits.com > There are tables t1( f11, f12) and table t2(f21, f22) and one > has to update field t1.f12 with values t2.f22 where t1.f11 = t2.f21. update t1 set f12 = (select f22 from t2 where f11 = f21); Igor Tandetnik

Re: [sqlite] Math Update with two tables

There are tables t1( f11, f12) and table t2(f21, f22) and one has to update field t1.f12 with values t2.f22 where t1.f11 = t2.f21. Mysql sample: 1. UPDATE t1, t2 2. SET t1.f12 = t2.f22 3. WHERE t1.f11 = t2.f21 He needs SQLite syntax. Dusan. Igor Tandetnik wrote: >

Re: [sqlite] Math Update with two tables

Dusan Gibarac wrote: > Igor Tandetnik wrote: >> "aj" wrote in >> message >> news:95d3c7350812201131l1cd87998k55595f77fecc0...@mail.gmail.com >> >>> UPDATE Records,Table2 >>> SET Factors= (Factors * Potential Table2.Field23) >>> >> >> This last

Re: [sqlite] Math Update with two tables

He wants to update table Records using data from table Table2. Dusan. Igor Tandetnik wrote: > "aj" wrote in > message > news:95d3c7350812201131l1cd87998k55595f77fecc0...@mail.gmail.com > >> I would like to use math with more then one table, for example >> I know how

Re: [sqlite] Math Update with two tables

"aj" 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) > >

[sqlite] Math Update with two tables

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