how to update multiple columns of a table from another table?.

[amitsukte]

Hi Everyone how should i update multiple columns of a table from another table...

Suppose I have table A and B and having four columns each table
A(col1,col2,col3,col4)
B(col1,col2,col3,col4)



then how should i do something like this

update A set(col2,col4)=(select B.col2,B.col4 from B where B.col1=A.col1 and A.col3=A.col3)

Please help..........

[r035198x]

Your basic query structure is correct but you should probably add a where exists

UPDATE A
SET ( A.col2, A.col4 ) =
( SELECT B.col2, B.col4
    FROM B
   WHERE B.col1 = A.col1
)
WHERE EXISTS
( SELECT B.col2, B.col4
    FROM B
   WHERE B.col1 = A.col1
)
 

[amitsukte]

thank you very much r035198x.. its working fine..