union 关联时属性字段顺序要一致
SELECT "门禁点" as regionname,online,count(*) as count
FROM yc_devicestatus
GROUP BY online
UNION ALL (SELECT "监控点" as regionname,online,count(*) as count
FROM camera_status
GROUP BY online
)
union 关联时属性字段顺序要一致
SELECT "门禁点" as regionname,online,count(*) as count
FROM yc_devicestatus
GROUP BY online
UNION ALL (SELECT "监控点" as regionname,online,count(*) as count
FROM camera_status
GROUP BY online
)