如何合并两个表的数据

[hjl13960]

我有两个表User1(Id,Name,Age,Sex,Addr),User2(Name,Age)
我想把User2的表的数据合并到User1,但是如果User2的Name+Age与User1的Name+Age一样的话，则不把数据导入。

这个sql要怎么写

[areswang]

怎么个格式呢？

[NBDBA]

insert user1(name,age) 
select name,age
from user2 a
where not exists (
  select 1 
  from user1
  where name=a.name
  and age = a.age
  )

[快溜]

insert into User1(name,age)
select * from User2 a
 where  not exists(select 1 from User1 where a.name=name and a.Age=Age)

[chuanzhang5687]

+1[Quote=引用 3 楼 ssp2009 的回复:]
SQL code

insert into User1(name,age)
select * from User2 a
where not exists(select 1 from User1 where a.name=name and a.Age=Age)
[/Quote]

[geniuswjt]

insert into User1(Name,Age)
select Name,Age
from User2 a
where not exists(
select 1 from User1 where Name+ltrim(Age)=a.Name+ltrim(a.Age)
)

[dawugui]

[Quote=引用楼主 hjl13960 的回复:]
我有两个表User1(Id,Name,Age,Sex,Addr),User2(Name,Age)
我想把User2的表的数据合并到User1,但是如果User2的Name+Age与User1的Name+Age一样的话，则不把数据导入。

这个sql要怎么写
[/Quote]

insert into user1(name,age) select name , age from user2 m where not exists(select 1 from user1 n where n.name = m.name and n.age = m.age)

[--小F--]

insert into
 User1(Name,Age)
select
 Name,Age
from
 User2 a
where
 not exists(select 1 from User1 where Name+ltrim(Age)=a.Name+ltrim(a.Age))

[newtees]

[Quote=引用 2 楼 nbdba 的回复:]
SQL code
insert user1(name,age)
select name,age
from user2 a
where not exists (
select 1
from user1
where name=a.name
and age = a.age
)
[/Quote]顶2楼