我有三个表,里边的结构一样name title content
An1 a1 b1
An2 a2 b2name title content
Bn1 a1 b1
Bn2 a2 b2name title content
Cn1 a1 b1
Cn2 a2 b2合成后,数据如:
name title content
An1 a1 b1
An2 a2 b2
Bn1 a1 b1
Bn2 a2 b2
Cn1 a1 b1
Cn2 a2 b2谢谢大侠
An1 a1 b1
An2 a2 b2name title content
Bn1 a1 b1
Bn2 a2 b2name title content
Cn1 a1 b1
Cn2 a2 b2合成后,数据如:
name title content
An1 a1 b1
An2 a2 b2
Bn1 a1 b1
Bn2 a2 b2
Cn1 a1 b1
Cn2 a2 b2谢谢大侠
union all
select * from tb2
union all
select * from tb3
select * from tb1
union all
select * from tb2
union all
select * from tb3楼主的结贴率有一些底.
union
select * from tb2
union
select * from tb3