Re: [sqlite] Update with two tables

[Jim Dodgen]

this should work.

UPDATE T1
SET T1.colA = (select T2.colA from T2 where T1.colC = T2.colC),
   T1.colB = (select T2.colB from T2 where T1.colC = T2.colC)
WHERE EXISTS (select * from T2 where T1.colC = T2.colC);




Unit 5 wrote:

Hello,

I am trying to update values of some columns in a
table with fresh data from another table.  The two
tables have the same column definitions.  Is this
possible?  Even better would be if the two tables
could be the same; then I could use table aliases in
the update statement.

Here is what I would like to do:


UPDATE T1
SET T1.colA = T2.colA,
    T1.colB = T2.colB
FROM T1, T2
WHERE T1.colC = T2.colC


Thanks in advance!




__________________________________________________
Do You Yahoo!?

Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com