Hi,
I suspect u are having 2 problems here .1)Trasfering data from each table(DIFFERNT SINGLE COLUMN).
2)Calculations in final table.
If so then ur first problem can be solved with unions and the second with the calculation logic.
If both are done then we can close this issue i think.
Cheers.
Comments please....
Srihari Nandamuri