aspose file tools*
The moose likes JDBC and the fly likes Update with FROM table concept Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Update with FROM table concept" Watch "Update with FROM table concept" New topic
Author

Update with FROM table concept

Seetesh Hindlekar
Ranch Hand

Joined: Feb 13, 2004
Posts: 244
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

Joined: Aug 13, 2004
Posts: 1081

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


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Seetesh Hindlekar
Ranch Hand

Joined: Feb 13, 2004
Posts: 244
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Update with FROM table concept