A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
OCM Java EE 6 Enterprise Architect Exam Guide
this week in the
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
Improving performance of view
Projection from inner join
data migration from one table to the other
Question of using SqlResultSetMapping
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014