多表连接的问题???

[fsunrise]

目前我有A1、A2、A3三张表,三张表的结构完全相同，我在这三张表中进行数据连查的时候SQl语句该如何写。（如何能把A1、A2、A3的数据连到一个数据集中进行查询）

[sdhdy]

select * from a1
union all
select * from a2
union all
select * from a3

[sunshareforever]

努力学习！天天向上：：：

select * from A1 union

select * from A2 union

select * from A3

[sdhdy]

select * from a1
union all
select * from a2
union all
select * from a3

[sdhdy]

--如果过滤掉重复记录的话
select * from a1
union
select * from a2
union
select * from a3

[fsunrise]

在线等待。。。

[zarge]

Select * from A1
Union
select * from A2
Union
Select * from A3

如果允许重复记录，则用Union All

[fsunrise]

低级问题，一时忘记

[97866]

Selecct * from (select * from a1 union all select * from a2 union all select * From a3)A where a.field1='abc'