590
社区成员
发帖
与我相关
我的任务
分享
SELECT sum(cnt) FROM (
SELECT COUNT(xmid) AS cnt FROM zxw_zxyy WHERE xmid REGEXP '(5)' UNION ALL SELECT COUNT(xmid) AS cnt FROM zxw_zxyy_mfbjlf WHERE xmid REGEXP '(5)') AS countdata
SELECT COUNT(xmid)+(SELECT COUNT(xmid) AS cnt FROM zxw_zxyy_mfbjlf WHERE xmid REGEXP '(5)') AS cnt FROM zxw_zxyy WHERE xmid REGEXP '(5)'