Insert many rows to another table

[Ajith Prasad]

I have 2 table, they are table A and table B
In "A" table i have 100 rows and in "B" table i have 200 rows. i want to insert all 100 rows in "A" table to "B" table. But i have no commons rows to match and no timestamp column available and i would like to insert all 100 rows in to Table "B" single statment

[Jan Cumps]

Hi Ajith,

Can you give us a bit more info? It's difficult to understand your problem from what you explained.

An example of some rows in table A and B, and the result that you expect will help.

Regards, Jan