sql server数据库中有两个表结构相同，我想把这两个表合并，但是合并后有名字重复的记录，

id也只保留一条? 后面两个字段什么类型? select min(id) as id,name,min(email) as email,min(tel) as tel from (select * from a union select * from b )a group by name