Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • 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
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!