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 ]