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:
> Dusan Gibarac <[email protected]> wrote:
>
>> Igor Tandetnik wrote:
>>
>>> "aj" <[email protected]> wrote in
>>> message
>>> news:[email protected]
>>>
>>>
>>>> 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?
>>>
>> He wants to update table Records using data from table Table2.
>>
>
> Hey, give me _some_ credit - I figured out as much. It's not clear
> precisely which pieces of data from Table2 should affect which records
> of Records, and in what way. What's the relationship between the two
> tables?
>
> 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
