怎么同时查询多个表的数据结果汇总到一起

先上问题： 我这里有十个表，我要在这十个表中查询字段tid = 40的结果 方法：

SELECT * FROM `yle_forum_attachment_0` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_1` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_2` WHERE `tid` = '50'
union all 
SELECT * FROM `yle_forum_attachment_3` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_4` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_5` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_6` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_7` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_8` WHERE `tid` = '50' 
union all 
SELECT * FROM `yle_forum_attachment_9` WHERE `tid` = '50'

 注意：所有表的结构必须一致才可以使用本方法！