Merging two tables to a new Table.

Hi All,

I am looking for a solution which can <b>merge two tables (Custom database) to a new table(Custom Database table).</b> <u><i>The tables already have data</i></u>. Now the new table will be having a few new fields those are not available to any one of these source tables. How to do that? I tried with infoset but not much sure of it and so requesting you guys to help me out of this.

Thanks in Advance.

Regs.

Somnath Paul