请教SQL连接语句是否正确？

爱棋子

SELECT "9月", * FROM [9月$] UNION ALL SELECT "8月", * FROM [8月$] UNION ALL SELECT "7月",  * FROM [7月$] UNION ALL SELECT "6月",  * FROM [6月$] UNION ALL SELECT "5月",  * FROM [5月$] UNION ALL SELECT "4月",  * FROM [4月$] UNION ALL SELECT "3月",  * FROM [3月$] UNION ALL SELECT "2月",  * FROM [2月$] UNION ALL SELECT "1月",  * FROM [1月$]   请高手为我看看我写的这个语句对不对呀？

monvzhilei

1. sELECT "9月", * FROM [9月$] UNION ALL
   
2. SELECT "8月", * FROM [8月$] UNION ALL
   
3. SELECT "7月", * FROM [7月$] UNION ALL
   
4. SELECT "6月", * FROM [6月$] UNION ALL
   
5. SELECT "5月", * FROM [5月$] UNION ALL
   
6. SELECT "4月", * FROM [4月$] UNION ALL
   
7. SELECT "3月", * FROM [3月$] UNION ALL
   
8. SELECT "2月", * FROM [2月$] UNION ALL
   
9. SELECT "1月", * FROM [1月$]
   

复制代码

貌似没有多少问题。

爱棋子

你的头象让人感觉是象小贝给我回答的，哈哈。