求SQL语句，将多个表合成一个表，每个表的结构不一样。要过滤重复的字段和行
求SQL语句，将多个表合成一个表，每个表的结构不一样。要过滤重复的字段和行

如：


tb1
(
id int primary key,
name varchar(10),
title varchar(10),
)

tb2
(
id int ,
name varchar(10),
title varchar(10),
address varchar(10)
foreign key (id) references tb1(id)
)

tb3
(
id int,
name varchar(10),
tel varchar(10),
address varchar(10)
foreign key (id) references tb1(id)
)




[解决办法]
have a try

select a.id as id,
a.name as name,
a.title as title
b.address as address
c.tel as tel
into youur_new_table
from tb1 a,
(select distinct id, address from tb2) b,
(select distinct id, tel from tb3) c
where a.id = b.id
and a.id = c.id

[解决办法]
select distinct tab1.id,distinct tab1.name,distinct tab1.title,distinct tb2.name,
distinct tab2.title,distinct tab2.address,distinct tab2.name,distinct tab3.tel,
distinct tab3.address
from tab1 left join tab2 left join tab3