八张结构相同的表如何实现同时检索

[csxsjt]

我有8张表，在检索时，希望检索一条满足检索条件的记录的时候再这八张表里同时检索出满足条件的记录

[zjexe]

什么意思

[csxsjt]

就是跨表检索

[divmedia]

?

[simonhehe]

select * from
(
select * from tb1 where [条件] union all
select * from tb2 where [条件] union all
select * from tb3 where [条件] union all
select * from tb8 where [条件]
) a
where [条件]

[csxsjt]

为什么表的结构相同，一跨表检索，实际只检索最后一张表