• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Update with FROM table concept

 
Seetesh Hindlekar
Ranch Hand
Posts: 244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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



Shailesh
 
Seetesh Hindlekar
Ranch Hand
Posts: 244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic