Bob, It looks like your datatypes don't quite match. You could try ((1.0 * t1.sevenft) + t2.Mo_Qty) Bill
On Thu, Dec 4, 2008 at 12:11 PM, Bill Downall < [EMAIL PROTECTED]> wrote: > Bob, > Do you get what you expect when you do this: > > SELECT t1.sevenft, t2.Mo_Qty, (t1.sevenft + t2.Mo_Qty) + > FROM bunktable t1, totals_view t2 + > WHERE t1.mo_number = t2.mo_number > > Bill > > > On Thu, Dec 4, 2008 at 12:04 PM, <[EMAIL PROTECTED]> wrote: > >> R>update bunktable set sevenft = (t1.sevenft + t2.Mo_Qty) from bunktable >> t1, totals_view t2 where t1.mo_number = t2.mo_number >> Columns have been updated in 1 row(s) in BunkTable >> >> > >
