update from an inner join? 1

[daglugub37]

OK I have 2 identical tables.

table1
col_ID
colA
colB

table2
col_ID
colA
colB

How can I update table1.colA, table1.colB from table2, using col_ID as a join?

 

[gmmastros]

[COLOR=blue]Update[/color] Table1
[COLOR=blue]Set[/color]    Table1.ColA = Table2.ColA,
       Table1.ColB = Table2.ColB
[COLOR=blue]From[/color]   Table1
       [COLOR=blue]Inner[/color] [COLOR=blue]Join[/color] Table2
         [COLOR=blue]On[/color] Table1.Col_Id = Table2.Col_Id

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[monksnake]

This will work: (*tested A+ seal of approval)

update table1 set colA = b.colA, colB = b.colB from table1 a inner join table2 b on a.col_ID = b.col_ID

<.

 

[TimothyCederdahl]

something like this should work.

Select a.colA
from table1 a inner join table2 b on a.col_Id = b.col_id
Update table1
set a.cola = b.colb

 

[daglugub37]

thanks all, for some reason i was making it more complicated then it needed to be.