Bill,
R>SELECT t1.sevenft, t2.Mo_Qty, (t1.sevenft + t2.Mo_Qty) FROM bunktable t1,
totals_view t2 WHERE t1.mo_number = t2.mo_number
t1.sevenft t2.Mo_Qty (t1.sevenft + t
---------- --------------- ---------------
13 21. 13.
Sevenft is integer while MO_qty is real. However, I believe these should still
add together?
R>set var x real = 5
R>SELECT t1.sevenft, t2.Mo_Qty, (t1.sevenft + .x) FROM bunktable t1,
totals_view t2 WHERE t1.mo_number = t2.mo_number
t1.sevenft t2.Mo_Qty (t1.sevenft + .
---------- --------------- ---------------
13 21. 18.
I can add a real variable to the integer column anyway.
I could not spend any more time figuring this out, so I simply computed
variables and
updated the table via variables. Not as "SQL" as I would like, but it works.
Thanks all.
Bob
--
Thompson Technology Consultants
LaPorte, IN 46350
219-363-7441
-------------- Original message --------------
From: "Bill Downall" <[EMAIL PROTECTED]>
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
