I have two tables with almost identical fields.
table A
inv_cd chr(3)
balance n(10,2)
interest n(10.2)
discount n(10,2)
table B
inv_cd chr(3)
balance n(10,2)
interest n(10.2)
premium n(10,2)
I need to create a select statement that will produce table C
inv_cd chr(3)
a.balance+b.balance as balance
a.interest+b.interest as interest
discount n(10,2)
premium N(10,2)
I need to accumilate like inv_cd's into one record.
I hope I explained myself
any help will be appreciated
God Bless America