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

缺少别名，应该在最后一行加上别名，比如：

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 tempTableAlias