Update with FROM table concept

[Seetesh Hindlekar]

Hello all,

Has anyone used the Update using the From considering the following scenario.

Update table statement
set col1 = table1.col44, col2 = table2.col555
FROM table1, table2
Where conditions

Rgds,

Seetesh

[Shailesh Chandra]

Originally posted by Seetesh Hindlekar:
Hello all,

Has anyone used the Update using the From considering the following scenario.

Update table statement
set col1 = table1.col44, col2 = table2.col555
FROM table1, table2
Where conditions

Rgds,

Seetesh

I dont think above query will work

try this

UPDATE TABLE2 SET COL1= (SELECT COL1 FROM TABLE1 WHERE CONDITION), 
COL2 = (SELECT COL2 FROM TABLE1 WHERE CONDITION)

Shailesh

[Seetesh Hindlekar]

Hello Shailesh,

Thks for the tip.

Will try for this logic as i had a common set of conditions to be met. Will seperate them now for the time being.

Will revert back on this forum if I have any doubts.

Tkhs again,

Seetesh