Inserting non duplicate values

[Dabase]

Hi,

I have 2 tables as follows:

MyTable
-------
Australia
USA
UK

OtherTable
----------
Australia
Argentina
Armenia
Ukraine
Uganda
USA
UK


I need to insert the values from OtherTable into MyTable without creating any duplications.

Any ideas how I can go about doing this?

Thanks
Dabase

 

[SQLDenis]

something like this
insert into MyTable
select * from OtherTable o
where not exists(select * from MyTable m where o.Country =m.Country)

or

insert into MyTable
select * from OtherTable o left join
MyTable m on o.Country =m.Country
where m.Country is null



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/