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 > >

