*
The moose likes JDBC and the fly likes DB2 Update Sql based on calculation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 Update Sql based on calculation " Watch "DB2 Update Sql based on calculation " New topic
Author

DB2 Update Sql based on calculation

Amanda Fu
Ranch Hand

Joined: Jul 17, 2003
Posts: 31
I have 3 tables with fields,

table1.col1,
table2.col2,
table3.col3,

Now I need to update table3.col3 with the value based on calculation like (table3.col3 * table1.col1 / table2.col2). How to do this use a update clause?

Any response will be appriciated.
[ September 21, 2004: Message edited by: Bear Bibeault ]
 
wood burning stoves
 
subject: DB2 Update Sql based on calculation
 
Similar Threads
Question of using SqlResultSetMapping
Improving performance of view
Projection from inner join
Simple sql
data migration from one table to the other