以下语句查询结果出错SELECT FROM SELECT count pricNum FROM news_price DATA WHERE DATAdel_flag = 0 AND DATAapproval_progress = 3 UNION SELECT count prodNum FROM ne

缺少别名，最后一个括号后应该加上“AS temp”。正确的查询语句应该是：

SELECT * FROM ( ( SELECT count() pricNum FROM news_price DATA WHERE DATA.del_flag = 0 AND DATA.approval_progress = 3 ) UNION ( SELECT count() prodNum FROM news_production_data DATA WHERE DATA.del_flag = 0 AND DATA.approval_progress = 3 ) UNION ( SELECT count() purcNum FROM news_supply_chain_data DATA WHERE DATA.del_flag = 0 AND DATA.approval_progress = 3 ) UNION ( SELECT count() protNum FROM news_port_data DATA WHERE DATA.del_flag = 0 AND DATA.approval_progress = 3 ) UNION ( SELECT count(*) warDNum FROM news_warehouse_data DATA WHERE DATA.del_flag = 0 AND DATA.approval_progress = 3 ) ) AS tem