A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
DB2 Update Sql based on calculation
Joined: Jul 17, 2003
Sep 21, 2004 13:48:00
I have 3 tables with fields,
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 ]
I agree. Here's the link:
subject: DB2 Update Sql based on calculation
Question of using SqlResultSetMapping
Projection from inner join
data migration from one table to the other
Improving performance of view
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014