wood burning stoves 2.0*
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
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 ]
 
Consider Paul's rocket mass heater.
 
subject: DB2 Update Sql based on calculation