求助：利用SQL合并多个表格数据问题

luckyzlei

SELECT * FROM [上海$] union all
SELECT * FROM [北京$] union all
SELECT * FROM [成都$] union all
SELECT * FROM [广东$] union all
SELECT * FROM [哈尔滨$] union all
SELECT * FROM [杭州$] union all
SELECT * FROM [济南$] union all
SELECT * FROM [临沂$] union all
SELECT * FROM [南京$] union all
SELECT * FROM [宁波$] union all
SELECT * FROM [青岛$] union all
SELECT * FROM [深圳$] union all
SELECT * FROM [沈阳$] union all
SELECT * FROM [苏州$] union all
SELECT * FROM [天津$] union all
SELECT * FROM [无锡$] union all
SELECT * FROM [潍坊$] union all
SELECT * FROM [武汉$] union all
SELECT * FROM [西安$] union all
SELECT * FROM [烟台$] union all
SELECT * FROM [长春$] union all
SELECT * FROM [长沙$] union all
SELECT * FROM [郑州$] union all
SELECT * FROM [重庆$] union all
SELECT * FROM [南昌$] union all
SELECT * FROM [石家庄$] union all
SELECT * FROM [淄博$] union all
SELECT * FROM [合肥$] union all
SELECT * FROM [厦门$]        想利用SQL语句合并多个表格，但是发现只能实现15个表格，超出数量就会显示无法查询表格（比如上述代码，写到天津终止，则可以查询到数据，多一个就会显示无法查询到表[上海$]），求解是什么原因？解决办法？

刀羊

即使有限制也应该足够使用的吧？
LZ不妨将文件上传看看有无问题。

huxy

占位，坐等大师来解答

zhaoguangfei

据说是可以同时union all 50个表的。。。