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