Merge 2 Tables

Hi All
How to Merge 2 Tables ?
Any Ideas Please
THanks
do they have the same schema?
If so I'd try something like this
insert into table2
select * from table1
If you have primary key collisions try this
insert into table2
select * from table1 where table1.pk not in (select pk from table2)
"TZ" <TZ@.discussions.microsoft.com> wrote in message
news:A97B6000-C7F3-4708-9A4A-0D3D8BED6D28@.microsoft.com...
> Hi All
> How to Merge 2 Tables ?
> Any Ideas Please
> --
> THanks