posted 17 years ago
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